|
niki_nilu wrote: objVarInit.sqlDA = query
query is the variable? or the query string that you put in SqlDataAdapter? then, you can use StringBuilder to append the string.
|
|
|
|
|
hello
i am using asp.net with c#.
objVarInit.sqlDA = new SqlDataAdapter("select tU.UserID,tU.FirstName,tU.LastName,tU.LastName+''+ tU.FirstName'UserId',tA.AnalystAssignHistoryCode,tA.SecurityCode,tA.ISIN,tA.StockName,tA.UserID,tA.IsDummyEnabled,convert(varchar(10),getdate(), 101)AnalystAssignDate,tA.StatusCode,tA.CreatedBy,convert(varchar(10),getdate(), 101)CreateDate,tA.UpdatedBy,convert(varchar(10),getdate(), 101)UpdateDate from tAnalystAssignHistory tA, tUser tU where tA.UserId = tU.UserId and tA.SecurityCode = ('" + txtSecurityCode.Text + "')", objClsDllSql.sqlCon);
In my project above code having in one line.
But i want above code in multiline, for comfortable otherwise i want to move horizontal scroll bar.
if i enter after some code then error.
so i want how to join multiline code.
Gayatri
|
|
|
|
|
|
pls give me one line example.
because i used it last of line. but error is comming.
Gayatri
|
|
|
|
|
StringBuilder sBdr = new StringBuilder();<br />
sBdr.Append("SELECT ");<br />
sBdr.Append("FieldName1, FieldName2 ");<br />
sBdr.Append("FROM YourTable");<br />
<br />
|
|
|
|
|
in my project i have long line.
i want to divide it in multiple line.
then which syntax will use.
i hope you will send me a write syntax.
thanks
Gayatri
|
|
|
|
|
Hi,
I need to display a image in grid view. the image will vary for every record (i.e) if the data in the row is of less priority then the image will be in red color and if it is in high priority, then of some other color. and Probably the image will be stored in the database
Can somebody suggest some mechanism for this.
Thanks in advance
|
|
|
|
|
Hi,
in the dataRowBound event of gridview you can write code for the same.
You have to add one column in that you can bind data for priority,
then in another column add template field and add image in that,now in dataRowBound event check for priority column and accordingly bind image.
Hope it will help you.
Thanks,
Sun Rays
To get something you must have to try once.
My Articles
|
|
|
|
|
|
Thanks for all your reply..
I have a dropdownlist and i select one value and saves it in database and bind it into a grid..If i select the grid row i want to dispaly the saved dropdownlist data in the dropdown that it is been selected.how is it possible..Plz help me sending the code for rebind the grid data into dropdown..
|
|
|
|
|
Hi,
All what u have to do is, on RowDataBound, u must search for the dropdown box on that row and then make the database value as selected value for that drop down. this is the only solution
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Hi,
I want to convert a particular integer value into indian currency format.
I am using this particular code, but it is resulting in dollars. I want the output in rupees format.
int price = String.Format("{0:C}",1234567);
Thank you
|
|
|
|
|
I think you should set the culture as hindi (or your culture) before calling this line.
|
|
|
|
|
But Hindi or india is not available in regional settings
Any code from aspx page to do that.?
|
|
|
|
|
|
Before I get into SIlverlight, I could use getting ASP.NET up and running.
I am trying to write my very first ASP.NET program.
I wrote a simple "Hello World" program and when I clicked on the button to run the code I got
[IMG]http://i67.photobucket.com/albums/h292/Athono/debugenabled.png[/IMG]
But I figured that would be ok. I selected to "Add New Web.config file" and I clicked OK.
But then I got this error message:
[IMG]http://i67.photobucket.com/albums/h292/Athono/debugenabled2.png[/IMG]
Can anyone offer any suggestions?
|
|
|
|
|
Maybe the IIS is not set up to run asp.net ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
You may also post the error message here because there are some people like me who can't access photobucket from our office...
|
|
|
|
|
IIS was installed and started after the .NET framework.
This was the cause of some problems.
But I fixed it.
On the command line, I went to
C:\WINDOWS\Microsoft.NET\Framework\
and went to the directory of the latest version:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
and I typed
aspnet_regiis -i
the computer responded that it was installing ASP.NET
and now, my programs work.
|
|
|
|
|
Hi,
My table has primary key, but I still can't apply optimistic concurrency on it.
Does anybody know why?
I'm using Web Developer 2005 express edition
|
|
|
|
|
Hello All,
Thanks for reading this post. Here is my question.
One of the development teams in my company is building the company website using ASP.NET. My team is building an ASP.NET website which part of the website. My app is going to reside as an application folder inside the main app. Iam using forms authentication for my site.
One of the requirements is after performing login into the main site, if the user clicks on a particular link it should log the user directly onto my site as well(Single Sign On). However much I try, on clicking on the link on the main page, it always goes to the logon page on my application because of forms authentication. How can i use forms auth to sign the user into my application and go directly to the page. The user id is stored in a cookie. Can i create a basepage which actually does the forms auth and pages inherit from it?? I have explained the scenario in very simple terms and it is more complicated than this.
Basically this is what i want to do...lets say my site is www.abc.com
i log in...and reach page abc.com/A.aspx ...i click on a link which will needs to take me to abc.com/appFolder/C.aspx....but when I do this, I always go to abc.com/appFolder/B.aspx which is the login page for appFolder(forms auth).. plz help...sample code highly appreciated.
Thanks
RH
|
|
|
|
|
I have this problem too.
Can anyone help me?
I use Forms authentication and have 3 .aspx pages:
1) Login.aspx
2) Default.aspx
3) Another_one_page.aspx
I open my Login.aspx, succesfully log in and redirect myself to Default.aspx. But when I try to go to Another_one_page.aspx from Default.aspx:
Response.Redirect("~/Another_one_page.aspx");
my browser redirect me to the Login.aspx page.
And when I insert credentials into Login.aspx, I will be redirected to the Default.aspx page again.
So, the Another_one_page.aspx is fully unavailable.
Thanks for any useful information!
modified on Monday, April 6, 2009 3:57 AM
|
|
|
|
|
couple of things.
1.check if the forms auth cookie is being set after you login.
2. try response.redirect("Another_one_page.aspx",false);
|
|
|
|
|
I'm working upon a small project where I ask the user for there house number and postcode. I then want to automatically search for the users address so they can select the right one and save this to the database. Has anyone attempted anything similiar and if so could they describe the best way of going about this task. Any help is much appreciated. Also please note this is to only work with address in the UK.
Thanks
|
|
|
|
|
You would need to purchase an address database, unless you fancy compiling a list of all UK address yourself. At my company we use the Royal Mail Postcode Address File[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
