|
Hi,
I'm currently developing a large scale ASP .NET application, and so far I've developed it using Access, after research, I don't think Access is going to handle the amount of usage we expect it to get, therefore I'm looking to switch to SQL Server.
Is there anyway I can do this seamlessly and quickly?
Thanks,
Aaron
|
|
|
|
|
Aaron Hudson wrote: Is there anyway I can do this seamlessly and quickly?
Export Data using Access or Import using SQL Server
|
|
|
|
|
Is it as straight forward as that?
Me = dumb
|
|
|
|
|
thereis another thing u\d need to do and that is to alter the db connection from ur application. SQL Server is not accessed the same way as Access is.
but i think it shouldn't be too much of work
Rocky
u cant climb up a ladder with ur hands in ur pockets
|
|
|
|
|
Yeah I knew about the code change.
The scenario is, I don't want to spend a couple of thousand on the full SQL, so what I've heard is that you can use SQL Express (has like a 2gb size limit I think) for now, while the project is small, and then when it brings in money, upgrade to the full.
Now the issues are:
1. Does this work / Will I have any issues in changing from Express to the full version?
2. How do I convert Access to SQL Express? (if #1 is ok)
Thanks
|
|
|
|
|
offcourse it works and importing data is a very simple task i think
just make a new database in SQL Server and right click on it > All Tasks> Import data> From data providers select MS Access, then select the Access file, give user name password if necessary and carry on with the wizard... I think that should be it
Rocky
|
|
|
|
|
There used to be an SQL Server upsizing wizard that would automatically upgrade from Access to SQL Server.
You would then probably want to do some work to make the best use of SQL server but it should work fine without the extra work.
Russell
|
|
|
|
|
How to access the values of hidden fileds of form A in form b?
Sessions or querystrings should not be the option! I heard we can access any control of one form in another using persistpage class in 2.0 however iam using 1.1 and c# can i access these hidden fields?
Gautham
|
|
|
|
|
What's done in .NET 2.0 is that an object instance of another page can be created, and that object consumes the data in the Request.Form collection so that you can access the values using that page object.
All the data that was posted to the page is available in the Request.Form collection. You can access those values directly, there is no need to instantiate another page object to do so.
---
single minded; short sighted; long gone;
|
|
|
|
|
hi friend
i have hash table where we store key and value. on value place i stored one more hash table so how i get that value which is store in value hash table
help me
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
Hi Friend:
Here is code for getting child hashtable value.
//Make main Hash table
Hashtable mainHashTable = new Hashtable();
//Make child Hash Table
Hashtable childHashTable = new Hashtable();
//Add child hash table value
childHashTable.Add("ChildValue", "Mubashir");
//Add child hash table to main hash table
mainHashTable.Add("HashTable", childHashTable);
//Get Child Hash table value
((Hashtable)mainHashTable["HashTable"])["ChildValue"].ToString()
|
|
|
|
|
but i have many walu in child hash table like this:-
Dim ConfId As String
Dim meesage As String
Dim SinglNode As System.Xml.XmlNode = xRequests.SelectSingleNode("/cwaEvents/conference")
ConfId = SinglNode.Attributes("confId").InnerText
Dim SinglNode1 As System.Xml.XmlNode = xRequests.SelectSingleNode("/cwaEvents/conference/messageReceived/message/content")
If SinglNode1.InnerText <> "" Then
meesage = SinglNode1.InnerText
'M_MessageTextHTAble = M_MessageHTAble.Item(ConfId)
M_Messagecounter = M_Messagecounter + 1
M_MessageTextHTAble.Add(M_Messagecounter, meesage)
M_MessageHTAble.Remove(ConfId)
M_MessageHTAble.Add(ConfId, M_MessageTextHTAble)
End If
Return M_MessageHTAble
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
Step 1 :
Get the Fist M_MessageTextHTAble from the M_MessageHTAble by ConfId
Step 2 :
Get the all item from M_MessageTextHTAble by For each statement
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
This code works for you. You can add different items in child node.
These item can be of any type.
All you need is type casting.
Lets suppose you added SinglNode of XMLNode type in child hash table.
You shall use this line for getting that object
((XMLNode)((Hashtable)mainHashTable["HashTable"])["ChildValue"]))
This line first get the value of child table then convert it to XMLNode.
You can add multiple different objects in hash table.
//Make main Hash table
Hashtable mainHashTable = new Hashtable();
//Make child Hash Table
Hashtable childHashTable = new Hashtable();
//Add child hash table value
childHashTable.Add("ChildValue", "Mubashir");
//Add child hash table to main hash table
mainHashTable.Add("HashTable", childHashTable);
//Get Child Hash table value
((Hashtable)mainHashTable["HashTable"])["ChildValue"].ToString()
|
|
|
|
|
This helpful to extract the whole list of key & values when debugging:
Public Shadows Function ToString(ByVal hashTable As Hashtable) As String
Dim s As String = String.Empty
Dim enumerator As IDictionaryEnumerator = hashTable.GetEnumerator()
While (enumerator.MoveNext())
s += enumerator.Key & ": " & enumerator.Value & ControlChars.NewLine
End While
Return s
End Function
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Response.Write("alert('"+ID.ToString()+"')");
I am writig the code in VB for a asp application but the statement is giving an error at the last semicolon " character is not valid"
Pl help
Regards
Prakash Mishra(Banglore,India)
|
|
|
|
|
Prakash_Mishra wrote: Response.Write("alert('"+ID.ToString()+"')");
In VB semicolon is not required.
Instead you need to place the semicolon after your alert statement.
Apurva Kaushal
|
|
|
|
|
I wrote the code like this
Dim con3 As New SqlConnection
con3.ConnectionString = "workstation id=R21;packet size=4096;integrated security=SSPI;data source=R21;persist security info=False;initial catalog=Test"
Dim ID As String = "select Cand_Id from Feedback where Cand_Id in(select Max(Cand_Id) from Feedback )"
con3.Open()
Dim cmd3 As New SqlCommand
cmd3.CommandText = ID
cmd3.Connection = con3
cmd3.ExecuteNonQuery()
con3.Close()
Response.Write("alert('" + ID.ToString() + "')")
But in the alert box its showing the output as the entire query not thr id
OUT PUT = select Cand_Id from Feedback where Cand_Id in(select Max(Cand_Id) from Feedback )
But i want my out put to be 1 , 2 .... like this
PL help
Prakash Mishra(Banglore,India)
|
|
|
|
|
This is happening because the text what you have stored in string ID is the same what you are getting. What you need to do is to store the data (what sqlquery is returning) in dataset and then use dataset to display the data.
Apurva Kaushal
|
|
|
|
|
This is the code i wrote in which i used the dataset but how to assign the value of dataset into the ID variabe iam not geeting, If possible pl modify the code and send me its having error and I am not getting what to do Pl help me Apurva
Dim con3 As New SqlConnection
Dim cmd3 As New SqlCommand
con3.ConnectionString = "workstation id=R21;packet size=4096;integrated security=SSPI;data source=R21;persist security info=False;initial catalog=Test"
con3.Open()
Dim ds3 As New DataSet
Dim queryString3 As String = "select Cand_Id from Feedback where Cand_Id in(select Max(Cand_Id) from Feedback )"
cmd3.CommandText = queryString
cmd3.Connection = con
Dim sqlda As New SqlDataAdapter(queryString3, con3)
sqlda.Fill(ds3)
ID = ds3
Response.Write("alert('" + ID.ToString() + "')")
con3.Close()
Regards
Prakash Mishra(Banglore,India)
|
|
|
|
|
Prakash_Mishra wrote: ID = ds3
Inspite of that take it as this:
ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString();
Apurva Kaushal
|
|
|
|
|
If i am writing that line i am getting the following error
value of type 'SystemData.DataTableCollection' can not be converted to string
Prakash Mishra(Banglore,India)
|
|
|
|
|
What exactly is the line which you have used?
Apurva Kaushal
|
|
|
|
|
ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString()
Prakash Mishra(Banglore,India)
|
|
|
|
|
Is ID is of string type?
put like this:
string ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString()
Apurva Kaushal
|
|
|
|