|
i'm using sql server login & password
|
|
|
|
|
I've installed SQL Critical Update Kit 3.0
Now i can access sql server using asp.net
Thanks
|
|
|
|
|
Your server name is incorrect. and or your password.
Create a test form and add a data source. Use the IDE to log on to it. Then grab the connection from there.
Its always easiest to let the environment create it for you first.
If you have VS2003 its even easier. Use Server Explorer. Find your table and drag it onto the form. It creates the entire connection object for you. Just open up the code and copy and paste.
Nick
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
i'm using VS2003. I tried your method, it displays the following error.
Login failed for user COMP\ASPNET'.
-- modified at 13:40 Friday 28th July, 2006
|
|
|
|
|
Did you try dragging the table onto the form?
If so, then that means you need to allow the ASPNET user to query your database
I would use a different user tho
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
I dragged the table. and write the following code in the page_load event
Dim ds As New DataSet
SqlDataAdapter1.Fill(ds)
Response.Write(ds.Tables(0).Rows(0).Item(0))
is that correct? Pls help. i'm confused
|
|
|
|
|
I've installed SQL Critical Update Kit 3.0
Now i can access sql server using asp.net
Thanks
|
|
|
|
|
cool.
But, going forward heres what I do if I'm unsure of the logins and server paths
I drag a stored procedure into the web form.
This will create 2 objects ( command and connection ) which you can see below the form.
The go into the code behind and inside the initialize created by the ID is your connection object. Just copy staht string and paste it into your web.config file.
You can also just view its properties in the designer.
Thats one of the tricks they taught in vb 6 and all that.
Nick
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
hai
ihave a datagrid with two columns and i added itemtemplate to them as result i got the two columns as: first with all labels and second with all textboxes . ok
as
col1 col2
xxx xxx
xxx xxx
col1 as all labels and col2 all as textboxes ok
but now is there any possibility to get in the second column as
1 row as button
2 row as textbox
3 row as label etc.
inthe second column of the grid
like i want to know if there is any template row in .net if not?
how to get this?
i think u got my point
plz any body help.....
|
|
|
|
|
You can add an html table in an item template. That html table can have as many rows / columns as you want.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
hai
iam again i got the point but not getting idea how to do
plz any body?
|
|
|
|
|
In design view right click on the datagrid and select edit template. Or just write out the HTML.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
Hello all,
In my asp.net 1.1 form,
i have 4 listboxes. if u select one in 1st ListBox, retrieving data fom DB and Populating in 2nd ListBox. same for 2nd ListBox selection and also same for 3rd ListBox and so on.
Here i want to avoid everytime retriving from DB.
anybody tell me which type of cache i have to follow to cache Listbox data
awaiting for response.
regards
GV Ramana
|
|
|
|
|
If you're not pulling back to many records then you could load all four query results into one dataSet with 4 datatables. You could cache the dataset or store it in viewstate. Then use a dataview to filter your datatable then bind the list box to the dataview.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
Hi guys,
I keep posting on formating Dates in the BoundField of a GridView control but all suggestions haven't yielded any good yet.
My Problem:
I'm using MySQL and as we know, it wants its date in "yyyy/MM/dd". Now the gridview I have shows the date's retrieved in this format: 7/30/2006 12:00 AM, meaning that the date is retrieved as "MM/dd/yyyy".
What I want:
I access this retrieved date on update to run my own simultaneous update on a database table. I therefore need the date in the "yyyy/MM/dd" format otherwise the MySQL server stores "0000-00-00" in the field.
I believe I'm clear enough now.
Someone proposed I use HtmlEncode="false" but it dosen't do Jack for me.
Thanks good people.
Live in fragments no longer. Only connect.
|
|
|
|
|
The GridView will not autoFormat the date for you in that way. Put code in the itemdatabound event to create a string and display the string.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06
|
|
|
|
|
well you need to tranform the data source. The grid view is pretty and all, but really has nothing to do with the data.
Im guess your calling Update on the DataSet?
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
|
When i click the Question in the code project site the details get opened. How is this happening.Please help.
-- modified at 9:47 Friday 28th July, 2006
|
|
|
|
|
Using Javascript to change the display style of elements.
---
b { font-weight: normal; }
|
|
|
|
|
Hi , i think the question was ssooooo clear
thank you
try to be good if you can't be the best
|
|
|
|
|
|
Hi,
I'm confused as to how should I create a login for my website administrative module.
There will be a number of users with administrative rights and other users with other rights such as billing department etc.
The users are in a sql database table.
every user type has a certain page access.
if a user not having admin rights tries to enter a page meant for admin, he should be denied access.
So how should i do it.
I've done this in ASP using session variables.
But how to do it in ASP.Net
I'm new to .Net and want a way better than ASP and simple way.
Thanks in advance
Regards,
Rizwan
|
|
|
|
|
You can check the usertype of the user in the page. And on having correct credentials only it will proceed otherwise will be redirected to the login page.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Search for Forms Authentication articles here on CP and you will find what you are looking for.
|
|
|
|
|
VS2005 come with login controls so it becomes a moot point.
--------------------------------------------------------
1 line of code equals many bugs. So don't write any!!
My mad coder blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
