Comments by Arora_Ankit

Arora_Ankit 1-Jul-15 6:14am View

So you basically want to handle null?
if yes you can insert an Item at 0 index of Dropdown after you bind it.

then if it is not null selectedValue=Value else 0.

Arora_Ankit 10-Nov-14 5:18am View

you are welcome:)

Arora_Ankit 5-Nov-14 0:22am View

how you will get data? From LIC or from your users.
If your users will enter all the details in DB then you can use simple one to one mapping for Policy Number and Client Detail and one to many for Client and Under Client

Arora_Ankit 31-Oct-14 8:11am View

add this code in Page_Load if you want to bind on page load
else wherever you want.

Arora_Ankit 31-Oct-14 7:09am View

Please check the solution. I put the code how you can handle the datatable for dates.

Arora_Ankit 31-Oct-14 6:49am View

declare a datatable
insert Today's Date
iterate a for loop from 1 to 60 and add that index in todays date to get required date insert that in datatable.
Then bind dropdown with that.

Arora_Ankit 28-Oct-14 4:06am View

Add onBlur event on the first textbox and use ajax to get projects for the task in that function.

Arora_Ankit 15-Oct-14 2:57am View

Welcome

Arora_Ankit 15-Oct-14 1:15am View

you want one subquery for each column. And multiple columns at a time?

Arora_Ankit 14-Oct-14 20:33pm View

He didn't mentioned how he is inserting data in other table.
The only thing i got from the question was that he is using an insert statement like this

If he will add unique constraint then insert will fail by throwing error but that will not solve is problem because he need to handle those details.

Moreover this query should be executed only once after all insert in first table are done.

Arora_Ankit 14-Oct-14 11:31am View

ID is correct?

Arora_Ankit 14-Oct-14 5:39am View

Yes Raj, that answer was correct and now I improved that for his need too.

Arora_Ankit 14-Oct-14 4:23am View

You are using Left Join. Please confirm you have data in that column for that row. Since left join will return data from first table(tbl_Company) and null for (tbl_Img) columns if tbl_Img has no row for that condition.

Arora_Ankit 14-Oct-14 3:44am View

Answer updated.

Arora_Ankit 13-Oct-14 10:10am View

Just add this function in your page's javascript and this will automatically call when page rendering completes

Arora_Ankit 13-Oct-14 7:26am View

are you using ajax/updatepanel?

Arora_Ankit 13-Oct-14 7:17am View

are you using partial postback?

Arora_Ankit 13-Oct-14 6:53am View

the query you gave will not work with and

Arora_Ankit 13-Oct-14 6:05am View

add following url on link button in grid 'login.aspx?id=<%# DataBinder.Eval(Container.DataItem, "UserID") %>'

in page load add this

var userID=Request.QueryString["id"] ?? string.Empty;
txtUserID.Text=userID;
This is C# code. same logic will work for you in VB

Arora_Ankit 9-Oct-14 7:10am View

Can you please mention the steps so that we can understand the scenario then only one can help you.

Please mention all the steps to replicate it.

Arora_Ankit 9-Oct-14 6:44am View

what is the exact issue that you are facing? are you getting full postback?
I used you code and it worked fine for me.

Comments by Arora_Ankit (Top 21 by date)