ASP.NET

SQLdataAdapter does not update when DB contains empty fields

29-Aug-06 23:40

Hi,
I am using datagrid in a datalist. in of the datalist i have put the datagrid. so that when the page is loaded i should see the data of datalist as well as datagrid.

In my datagrid there are 2 button "edit" and "delete".

when i want to edit the record in datagrid i am not able to get the selectede index of the datalist.

how to solve this problem that i should get the selected index of the datalist when i want to edit the item in the datagrid.

*******I do not want to put the datagrid in selected item template of the datalist.**********

thanks in advance...

Deepak

ThomasLu29-Aug-06 23:25

ThomasLu

29-Aug-06 23:25

My problem is as follows:

My DB (Access / SQWLExpress) contains empty fields.
I am using the AccessDataAdapter/SQLDataAdapter with Gridview and Detailsview.
All Textfields of the DB may contain empty strings. CancelselectonNullParameter is set to false.

As soon as a field of a dataset (in the DB) is empty, updates of this dataset is not possible. No error is thrown.

When the dataset does not contain empty fields I am able to update any changes even when I clear this field.

The attribut ConvertEmptyStringToNull="True|False" does not change the behaviour.

Has anybody got an idea?

Re: SQLdataAdapter does not update when DB contains empty fields

deepaks329-Aug-06 23:45

Re: SQLdataAdapter does not update when DB contains empty fields

29-Aug-06 23:45

Please use DBNull and see if it is working. In cases like yours , we store the query in the string datatype the then send the string to the DB. I am afraid in that cases null is also treated as empty string.

Regards
Deepak

ThomasLu30-Aug-06 1:08

ThomasLu

30-Aug-06 1:08

Thanks deepaks3! Rose | [Rose]

Found the solution. The issue lies within the automatic created queries when configuring the datasource. When updating to an empty field, the original value is compared to a string. This gives an error (without throwing one) in the database and no update is done!!

calling DB2 stored procedure using asp.net

playout29-Aug-06 22:14

playout

29-Aug-06 22:14

Hi,

I am having a lot of problems trying to get a stored procedure on a DB2 database to work.
I tried looking on the web, nothing.... or I am just blind out of frustration.

From what I could see, and my debugging, the code is fine... What happens is, my function runs the following code, and should return a value if successfull. However, when I go view my db2 database, it shows that the Stored Procedure has not run. But from my code, it looks like it did. Anyone who can help me out, PLEASE?

<br />
            Dim strSuccess As String = ""<br />
            ' Create instance of connection and command object<br />
            Dim objConn As IBM.Data.DB2.iSeries.iDB2Connection = New iDB2Connection(DB2SP()) 'DB2SP() is connection string in my web.cofig. It does work, as other code use the same string<br />
<br />
            Dim objCmd As IBM.Data.DB2.iSeries.iDB2Command = New iDB2Command("A1EXEC.LISTIMPORT", objConn)<br />
<br />
            ' Mark the command as a SPROC<br />
            objCmd.CommandType = CommandType.StoredProcedure<br />
<br />
            Dim strDivision As String = "C1"<br />
            Dim intPeriod As Integer = 200705<br />
<br />
            ' Add parameters to SPROC<br />
	    ' just done the basics here, to get it to work<br />
            objCmd.Parameters.Add(New IBM.Data.DB2.iSeries.iDB2Parameter("@division", strDivision))<br />
            objCmd.Parameters.Add(New IBM.Data.DB2.iSeries.iDB2Parameter("@period", intPeriod))<br />
<br />
            ' Execute the command<br />
            Try<br />
                ' Open the connection and execute the command<br />
                objConn.Open()<br />
                objCmd.ExecuteNonQuery()<br />
                strSuccess = "SP - Successful"<br />
            Catch ex As Exception<br />
                Dim strExceptionMsg As String = "Error Executing SP(): " & ex.Message & vbCrLf<br />
                Throw New Exception(strExceptionMsg, ex)<br />
            Finally<br />
                ' Close the Connection<br />
                If objConn.State = ConnectionState.Open Then<br />
                    objConn.Close()<br />
                End If<br />
                objConn.Dispose()<br />
                objCmd.Dispose()<br />
            End Try<br />
<br />
            Return strSuccess

how to synchronize dropdownlists

Kissy1629-Aug-06 22:00

Kissy16

29-Aug-06 22:00

Mr Apurva Kaushal who resopnded for my last days doubt,

Here for the first time when i select a state that will not display.Same happening in DIvision also.If i select second time all are working properly.so wat to do for this??? a
and i have a code like
Dim cnt As Integer
cmdcnt = New SqlCommand(" Select MAX(Centre_Id) from Division_District where District_Id='" & num & "'", dbConn)
cnt = cmdcnt.ExecuteScalar()
If cnt = 0 Then
cnt = 1
if max is null the nhow to compare that value with ordinary integer.Like Isdbnull() or something.

kissy

kissy

Re: how to synchronize dropdownlists

_AK_29-Aug-06 22:49

Re: how to synchronize dropdownlists [modified]

29-Aug-06 22:49

Kissy16 wrote:
Here for the first time when i select a state that will not display.Same happening in DIvision also.If i select second time all are working properly.so wat to do for this??

I don't see any reason why it will not work for the first time. Is the page is getting posted back or simply nothing is happening.

Kissy16 wrote:
Dim cnt As Integer
cmdcnt = New SqlCommand(" Select MAX(Centre_Id) from Division_District where District_Id='" & num & "'", dbConn)
cnt = cmdcnt.ExecuteScalar()
If cnt = 0 Then
cnt = 1

ExecuteScalar executes the query and return one value.
Here you can do like this:
cmdcnt = New SqlCommand(" Select MAX(Centre_Id) from Division_District where District_Id='" & num & "'", dbConn)
Dim r As SqlDataReader = cmdcnt.ExecuteScalar()
if(!sqlDataReader.IsDbNull(columnIndex))
Then do the operations here
endif

Best Regards,
Apurva Kaushal

Kissy1630-Aug-06 0:27

Kissy16

30-Aug-06 0:27

It doesnt display anything in any other two lists when i clicked on list1,and samething happend if select list2,list3.
If i attempted 2nd time all are working properly.
all the settings are correct.but not working for the first time.
I think the first statement in my selectedchanged event is "list.Items.clear()".Am i correct.For the secondtime it will work but for first time also it clears the list,Isn't it?
wat to do.

-- modified at 6:47 Wednesday 30th August, 2006

kissy

Re: how to synchronize dropdownlists

Kissy1630-Aug-06 1:12

Kissy16

30-Aug-06 1:12

kissy

Re: how to synchronize dropdownlists

_AK_30-Aug-06 1:25

Validation in asp:DataList

30-Aug-06 1:25

Kissy16 wrote:
t doesnt display anything in any other two lists when i clicked on list1

You have change something in the itemlist to get the event fired.

Kissy16 wrote:
think the first statement in my selectedchanged event is "list.Items.clear()"

In your case this is required.

Kissy16 wrote:
the secondtime it will work but for first time also it clears the list,Isn't it?

Why is it clearing the list as it will get executed only when you are changing something in the previous control, and in that case it is correct as it is clearing it and again filling it with the new data.

Best Regards,
Apurva Kaushal

deepaks329-Aug-06 21:10

29-Aug-06 21:10

Hi,
I am using a DataList control, and have a checkbox in it.
There is also a button whihc performs a certain action on the basis of which all check boxes are checked.

Now i want to validate on the click of the button that if no check box is checked then it should not do anything.

How can it be possible with JavaScript. (Client Side validation)
I basically want no postback to happen so that unnecessary server trip is avoided.

Thanks in advance.

Deepak Surana

_AK_29-Aug-06 21:34

29-Aug-06 21:34

What you need to do in javascript is to check the checkboxes whether they are checked or not.
Like this:

if(CheckBox1.checked)<br />
				{<br />
					alert("checked");<br />
				}<br />
				else<br />
				{<br />
					alert("not checked");<br />
				}

Best Regards,
Apurva Kaushal

deepaks329-Aug-06 21:47

29-Aug-06 21:47

This can work if there is only one check box, but i have a list of checkboxes..

_AK_29-Aug-06 22:50

29-Aug-06 22:50

In this case what you can do is to take a boolean value and iterate through all the checkboxes and if you get any checkbox checked then make the boolean value and then later just check the value and do the operation.

Best Regards,
Apurva Kaushal

deepaks329-Aug-06 23:51

loading temporary asp.net files takes ages [modified]

29-Aug-06 23:51

Can you please tell me how to write that function and where to call it.
Thanks.

livez29-Aug-06 21:00

livez

29-Aug-06 21:00

Hi!

Ive got a problem with debugging my asp.net application. Everytime I start the debugger the studio starts loading files from c:\windows\microsoft.net\framework\v1.1.4322\temporary asp.net, and this takes absolute ages, sometimes up to 10 minutes. But if I start debugger again without doing changes in code the loading time is instead a few seconds. Why does this take so long, and is there anything I can do to shorten the time it takes to load the temp files?

/regards Magnus

-- modified at 2:04 Friday 1st September, 2006

_AK_29-Aug-06 22:55

29-Aug-06 22:55

Remove all the temporary files and see.

Best Regards,
Apurva Kaushal

livez29-Aug-06 23:15

livez

29-Aug-06 23:15

Thanks for your response Apurva

Sadly I´ve already tried this to no avail. Loading times remains unchanged.

/regards Magnus

Jürgen Müller (jmse)30-Aug-06 6:30

Jürgen Müller (jmse)

30-Aug-06 6:30

Hi, Magnus.

...maybe your harddisk is broken.
I've had the similar behaviour some time ago (but with another app), and it turned out the harddisk was the problem.

Regards

Jürgen