ASP.NET

Manas Bhardwaj16-Jul-07 0:21

Manas Bhardwaj

16-Jul-07 0:21

Aaron Hudson wrote:
Is there anyway I can do this seamlessly and quickly?

Export Data using Access or Import using SQL Server Big Grin | :-D

Aaron Hudson16-Jul-07 0:28

Aaron Hudson

16-Jul-07 0:28

Is it as straight forward as that?

Me = dumb Blush | :O

Rocky#16-Jul-07 2:08

Rocky#

16-Jul-07 2:08

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 Smile | :)

Rocky

u cant climb up a ladder with ur hands in ur pockets

Aaron Hudson16-Jul-07 8:40

Aaron Hudson

16-Jul-07 8:40

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 Smile | :)

Rocky#16-Jul-07 17:11

Rocky#

16-Jul-07 17:11

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 Smile | :)

Rocky

how to get value from hash table

Russell Jones16-Jul-07 1:00

Russell Jones

16-Jul-07 1:00

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

Hidden Fields

gauthee15-Jul-07 22:41

gauthee

15-Jul-07 22:41

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

Re: Hidden Fields

Guffa15-Jul-07 22:50

Guffa

15-Jul-07 22:50

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;

Piyush Vardhan Singh15-Jul-07 22:16

Piyush Vardhan Singh

15-Jul-07 22:16

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

Mubashir Javaid15-Jul-07 22:44

Mubashir Javaid

15-Jul-07 22:44

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()

Piyush Vardhan Singh15-Jul-07 23:08

Piyush Vardhan Singh

15-Jul-07 23:08

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

Parwej Ahamad15-Jul-07 23:41

Parwej Ahamad

15-Jul-07 23:41

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

Mubashir Javaid15-Jul-07 23:43

Mubashir Javaid

15-Jul-07 23:43

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()

Help in Response.Write statement

-Dr_X-18-Jul-07 10:11

-Dr_X-

18-Jul-07 10:11

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)

Prakash_Mishra15-Jul-07 22:12

15-Jul-07 22:12

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)

_AK_15-Jul-07 22:42

15-Jul-07 22:42

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

Prakash_Mishra15-Jul-07 23:24

15-Jul-07 23:24

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)

_AK_15-Jul-07 23:33

15-Jul-07 23:33

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

Prakash_Mishra16-Jul-07 0:27

16-Jul-07 0:27

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)

_AK_16-Jul-07 0:44

16-Jul-07 0:44

Prakash_Mishra wrote:
ID = ds3

Inspite of that take it as this:

ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString();

Apurva Kaushal

Prakash_Mishra16-Jul-07 0:52

16-Jul-07 0:52

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)

_AK_16-Jul-07 1:03

16-Jul-07 1:03

What exactly is the line which you have used?

Apurva Kaushal

Prakash_Mishra16-Jul-07 1:05

16-Jul-07 1:05

ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString()

Prakash Mishra(Banglore,India)

_AK_16-Jul-07 1:18

16-Jul-07 1:18

Is ID is of string type?

put like this:
string ID = ds3.Tables[0].Rows[0]["Cand_Id"].ToString()

Apurva Kaushal

Prakash_Mishra16-Jul-07 1:30