split a database web application -
Application1 uses database1 on ServerX
Application2 uses database2 on ServerY
Both application communicates over web service API, they are apart of the same application, one application is used to manage user's profile/personal data, while the other application is used to manages user's financial data.
Or should just put them together and just use 1 database on the same server?
I displayed some words in text box.. The words are,
performcontextEmpRecordhostcontextEmpRefertlcontextEmpdatadatascontextEmpofficemain
contextEmppersonalhardwarecontextEmpsalaryhighcontextEmptype
Now, I want to store these words into database table using asp.net with c#..
each word should be stored into new row..(i.e words spilit into space)..
I would like to know if someone can please help me with the followingI would like to create a bulk entering textbox...every sentence seperated by a line break should go in to the Database as a new column.....Im gonna use SqlDatasource for the inserting..How can I get all the sentences to break up at the linebreak and then get inserted in a separate database column?
View 3 Replieshow to migrate an existing database from a specific application to a new Ms Access based application(database)?
View 4 RepliesI would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.
Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262
I have an existing SQL database containing student:class enrollments and would like to add a login feature using asp.net's built in Membership and Roles management tools. to how to integrate the Application Services Database with an existing SQL database? Once I have created the Application Services tables using aspnet_regsql tool how and where do I create a link between my tables and the .Net Membership tables?
View 5 RepliesI have a string value ie) = '1001010'
I want to split one word by one word.
like as
1
0
0
1
0
Need to take a string in vb and split it. Also need to look through the two returned values and return the value which contains "domain1.com". Pipelines are the delimiter.
txtEmailFrom.Text = "john@huno.com|james@domain1.com"
Dim brokened() As String
brokened = Split(txtEmailFrom.Text, "|")
Dont know where to go from here..
I am using the List in my application, here i am stored more that one items in my list. So here i want to split 14 by 14 records.
how to split the records from the List.
i have dataset ds with 4 coloums. the 4rth colom has values either '1' or '2'. i want to split this ds into 2 datasets ds1 and ds2 depending upon whether 4rth colom is '1' or '2' .
then i want to bind gridview1 to ds2 and gridview2 to ds22.
I have a column metricId in table Metric which have string values like '010277' or '0103444'.
I have to remove first four digits from the metricid and then get the Max value of the column.
I have IP address like 192.87.88.01 i want to split in 4 parts by dot separator
View 5 RepliesI am retrieving data using sqlreader like 60k records. After retrieving I need to split those records into N parts. I need to use those chunks of data in WorkFlows 4.0
View 5 RepliesRadikalGenc.aspx?phonenumber=5552451245&message=ISTAN-ALL-123;Emly,Foz,Praia,Sol,Luna,Trabalha
string number = Request.QueryString["phonenumber"].ToString();
string textMessage = Request.QueryString["message"].ToString();
I need the textMessage splitted int array Like this:
ISTAN-ALL-123 -> Presents Form name The list below, presents the fiels name
Emly
Foz
Praia
Sol
Luna
Trabalha
how can do that?
I retrieve the date & time from datetime field in sql using a reader:
[Code]....
This value returns e.g. 15/04/2010 8:00:00 but I would like to split the day value (15), month value (4) etc from the overall datetime value, so I can assign dropdowns with corresponding (preselected) day, hour selection ..I know the dropdown assignment process, but I can't get the datetime field/value split ..
I am able to populate a text box with a long string. This string is a collection of email addresses, I am wondering how I can split this string so that I am able to get the individual email addresses? If I select multiple email addresses it come through like Example: test1@test.comtest2@test.com in the one text box how could I split this so I could get test1@test.com in one text box and test2@test.com in another?
Code:
Protected Sub BtnEmailList_Click(sender As Object, e As System.EventArgs) Handles BtnEmailList.Click
' StringBuilder object
Dim str As New StringBuilder()
' Select the checkboxes from the GridView control
For i As Integer = 0 To GrdVwClassEmail.Rows.Count - 1
Dim row As GridViewRow = GrdVwClassEmail.Rows(i)
[Code].....
1) The image is from a asp:image tag
2) text is from asp:label
view here : [URL] How can I get text to start after the image is set in the top left corner, and then have text wrap underneath the image, if the text is long enough. I need to use asp:image and asp:labels as the inputs are populated from codebehind.
I have The following structure in my crystal report
Qty Rate
5 2,4,6
10 1,5,20
I need like this in my crystal report
Qty Rate Amount Total
5 2,4,6 10,20,30 60
10 1,5,20 10,50,200 260
My Table Structure
Table Name Table1
ItemName Rate
A 10
B 15
C 20
D 25
E 30
I have return a Sql Query in my code behind as
Select Rate from Table1 where ItemName(A,C,D);
The following Rate should be displayed in my textbox in this format 10,20,25
I have a string that has content like
<html xmlns:o="urn:schemas-microsoft-com:office:office"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><meta http-equiv="Content-Style-Type" content="text/css"
/><meta name="generator" " /><xml>
<o:DocumentProperties.......</body></html>��������"
I want to split the string on the basis of "</html>". I basically want to eliminate the �� junk after </html>. How can I do that?
I have string like these
abcd 45
abc dehfr 3
abcd refs lal 45
I have to get the string and number different. This is like the City with house number. So i want to split the city and house number. How do i do this.
I have field_1, the data format store in the field is about "Mary, Amy, Billy, Ma"
how can i extract the record that the field_1 has Mary.
I can't use the like'%Mary%' because it can extract 'Ma' too.
I would like to extract exactly Mary. or can i split the field_1 by ',' in sql?
I am developing web application using csharp and MS SQL as database. There is a column in table that is storing values which as numbers and letters. Letters are in front like JK26262, JK26263,JK26263.
Now I want to select numbers only from a table column and leave letters. In other words I want an select statement that will select values as follows:
26262
26263
26263
How can Iachieve this?
to run asp.net and asp classic in separate app pools? The asp classic pages are mixed within the same asp.net application and its sub folders. Basically, I have a site and would like to run the asp.net portion in its own app pool and asp classic in a separate app pool. The intent is to run asp.net in a "web garden" configuration; we can not currently do this if asp.net and asp classic are in the same app pool, due to the fact that the classic portions rely on session variables in process.
We have considered rewriting the classic so that they are self contained in one directory, and switching to an SQL-based session storage for classic. We determined it was easier to attempt to split the app pools, as these two options would require a significant time investment.
I am trying to split a collection into multiple collections while maintaining a sort I have on the collection. I have tried using the following extension method, but it breaks them incorrectly. Basically, if I was to look at the items in the collection, the order should be the same when compared to the broken up collections joined. Here is the code I am using that doesn't work:
public static IEnumerable<IEnumerable<T>> Split<T>(this IEnumerable<T> list, int parts)
{
int i = 0;
var splits = from name in list
group name by i++ % parts into part
select part.AsEnumerable();
return splits;
}
int parts = number of sub enumerables
