|
Hi, I would like to know the difference in implementation. Both of the ways would run the stored procedure. Which way is better?
Thank you.
SqlConnection con = new SqlConnection();
SqlCommand inboxDS;
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
inboxDS = new SqlCommand("InsertMessage", con);
inboxDS.Parameters.Add("senderUserName", Session
inboxDS.Parameters.Add("UserMessage", FCKeditor1.Value);
inboxDS.CommandType = CommandType.StoredProcedure;
con.Open();
inboxDS.ExecuteNonQuery();
con.Close();
/*************************************************************************************************
SqlDataSource inboxDS = new SqlDataSource();
inboxDS.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
inboxDS.InsertCommandType = SqlDataSourceCommandType.StoredProcedure
inboxDS.InsertCommand = "InsertMessage";
inboxDS.InsertParameters.Add("senderUserName", Session["user_n"].ToString());
inboxDS.InsertParameters.Add("UserMessage", FCKeditor1.Value);
inboxDS.Insert();
|
|
|
|
|
Dear All,
i have parent aspx page that have two controls, iframeParent and a buttonParent.
i have given child aspx page as the source of iframeParent control. child page has a buton control buttonChild.
now my requirement is
when i click the button(buttonParent)in the parent page the click event of the button(buttonChild)of child page should be called. is there any way to do this?
Thanks in advance
Ramesh.Kanjinghat
|
|
|
|
|
Hello all! I am new to the ASP.NET arena. I have a college project that I am doing that requires me to build an e-commerce website (my own idea, that will be online after it is completed). I need to know several things. I will list them below, and if anyone can point me toward some good research material, I would greatly appreciate it!!! The list of needed topics are as follows:
- Stored Procedures (within ASP.NET)
- Link ASP.NET login control to my SQL Server 2005 database (not through the Membership class)
- Anything else that may be of help that relates to Data access and manipulation within ASP.NET
I hope that I am not being to vague here! If anyone has any suggestions that could be of direct assistance, that would be great. However, I am
simply asking for some pointers to some valid research material. I have some books coming in the mail, but I need to get a head start on this project, as it is due in 6 weeks!  Any help would be greatly appreciated! Thanks.
|
|
|
|
|
MrColeyted wrote: Stored Procedures (within ASP.NET)
http://www.dotnetjunkies.com/Article/9AE62C44-3841-4687-B906-2F6D4A5A4622.dcik
|
|
|
|
|
Stored procs are easy to call in ADO.NET. ASP.NET has nothing to do with it.
Roll your own membership system, then you have complete control
ASP.NET has nothing to do with database access. However, ADO.NET works exactly like it does in winforms.
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 )
|
|
|
|
|
strored prosedures are complied objects,,,,you can use these to increase the processing of your projects,,,you just need to right click on the database name and the choose create stored procedures,,,then you can apply that procedures anywhere in your projects inspite of worryin abt typin the wueries again and again
jai mata di
|
|
|
|
|
|
Hello All
How can I perform goint to Next,Previous,First and last record of a dataset.
All of these events will be fired on click of the respective button.
I know that i have to use SqlDataReader but unable to implement the same.
Any Code will be helpful for me.
Ajay Kumar
|
|
|
|
|
MissionSuccess wrote: I know that i have to use SqlDataReader
Not true. There are numerous ways to define a data source.
You can set up the GridView, at least, to do this for you, but I prefer to write controls for the links and write a stored proc that takes a page number and count, and handle it myself.
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 )
|
|
|
|
|
Agreed SqldataReader is forward only....
But how can i achieve this...without any grid
I have a no of data for a record so i am not using datagrid.
I am showing it in different textboxes and dropdowns.
On the click of next or previous button the respected textboxes and dropdowns shd be filled automatically with the correct data.
Ajay Kumar
|
|
|
|
|
Hi all
I am not sure to post this question is suitable or not.
How/Can I select the columns of entire database tables? I am going to clear about the question.
For select all columns of one tabble.
Select * from TableName.
Similarly, what is the query for select * from *(all tables inside a database).
Thanks
|
|
|
|
|
If there is, then the SQL forum is the place to ask. I doubt it very much tho. For starters, that query can't work, b/c it doesn't establsih joins between tables, nor can it. I'm sure there's a SQL Server proc to find all tables in a DB tho.
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 )
|
|
|
|
|
|
Hi,
I have a problem with maintainScrollPositionOnPostBack. I tried to set it both in web.config and in the page itself. But whenever I do a postback the page is reset to the top. The code does seem to be in the source:
<div><br />
<br />
<input type="hidden" name="__SCROLLPOSITIONX" id="__SCROLLPOSITIONX" value="0" /><br />
<input type="hidden" name="__SCROLLPOSITIONY" id="__SCROLLPOSITIONY" value="0" /><br />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWBQK5pZrtBAKe1IqoDgK4/rF4Aqej2csJAuKqvZkDQeYzTVDEMVPMi9O+ZVyKPzO+3xc=" /><br />
</div><br />
<br />
<script type="text/javascript"><br />
<br />
theForm.oldSubmit = theForm.submit;<br />
theForm.submit = WebForm_SaveScrollPositionSubmit;<br />
<br />
theForm.oldOnSubmit = theForm.onsubmit;<br />
theForm.onsubmit = WebForm_SaveScrollPositionOnSubmit;<br />
</script>
The name of the site is www.entropedia.info. Anyone know what I am doing wrong?
|
|
|
|
|
Hi,
I used requiredFieldValidator in my web application and locally it's OK but when I publish it on my host, it don't work.
My host support ASP.Net 2.
Best wishes
|
|
|
|
|
Well, logically, that just can't be true unless there's something you're not telling us. A required field validator isn't going to change based on what hard drive or server it's on.
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 )
|
|
|
|
|
Hello friends,
I am using GridView to display my data. I wanted to enable a linkbutton located in a column of that grid on selectedindexchange. Is it possible? if yes ..how ?
thanks..in advance
Amit
|
|
|
|
|
You'll need to know the ids of your differnt buttons and do it using javascript. Unless you do a postback every time, which is ugly in this day and age.
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 )
|
|
|
|
|
i have developed an website in microsoft visual studio 2005 using asp.net
will it work properly in visual studio2003????
|
|
|
|
|
|
No, there were major changes between 2003 and 2005, so even if you had not used any new .NET 2.0 language features, I doubt it will work.
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 )
|
|
|
|
|
|
Hello. First of all I'm programming in VB.NET/ASP.NET doing a page for a website. Now, to my question....
I have a simple array of integer numbers (15 characters in length) which can hold up to 2000 items. What I basically need to do is output these numbers to a PDF file I'm creating on the fly and I can only fit a certain amount of numbers per page. What I need to do is just output these on each page in numerical order vertically NOT horizontally. Based on page size restrictions, the amount of numbers I can output per page is 19 rows x 7 columns (or 133 items total).
Now, I already have the PDF creation going fine, including adding more pages as there's more numbers being added, etc. It's just the sorting of these numbers that I'm outputting I'm having trouble with. What I'm doing currently (which is archaic), since I can only output horizontally at the moment, is outputting the first number, then skipping the next 18, and then outputting the next number, then skipping the next 18, etc. Once I get to the 7th number (1st row, 7th column), I output it, skip backwards to the 2nd number in the array, and output it as I'll now be in the 2nd row (2nd row, 1st column). I keep doing this until all numbers in the array are output. The only problem is that, other than being finicky and definitely not an efficient way of doing it, is if the array has fewer than 133 numbers (or if by chance there's fewer than 133 numbers on any one page), the output structure is all messed up.
For more info on what I'm currently doing, here's some code examples:
Dim theTagArray(2000) As String<br />
' theTagArray is filled before this next section...<br />
<br />
Dim thecount2 As Integer = 0<br />
Dim thecount3 As Integer = 0<br />
Dim thenum As Integer = 19<br />
' Nice mess to print tags in numeric order down each column, left to right...<br />
' Basically, start with first element, then skip 18 and put next, skip 18 put next, etc. and so forth...<br />
' pdfText2a.Add is the function that's basically outputting the array element... to the PDF...<br />
If thecount3 = 7 Then<br />
thecount2 += 1<br />
thecount3 = 0<br />
pdfText2a.Add(theTagArray(thecount2 + (thecount3 * thenum)) & " | ")<br />
thecount3 += 1<br />
Else<br />
pdfText2a.Add(theTagArray(thecount2 + (thecount3 * thenum)) & " | ")<br />
thecount3 += 1<br />
End If
I want it to look kind of like this:
982000018301450 | 982000018561709 | ...<br />
982000018561265 | 982000018561724 | ...<br />
...
Though 7 across, 19 down.
So, this is why I'm asking if there's a way to output an array vertically instead of horizontally in either a slightly more efficient way than I'm doing it, or by using a much better method altogether. Please help if you can. Thanks for your help.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." - Albert Einstein
|
|
|
|
|
There is no way I see to display an array vertically, but you can surely try putting your data in some DataTable vertically with an array and then print horizontally from the table to match your required output
Keep DotNetting!!
GeekFromIndia
|
|
|
|
|
Oh, I wish it were that easy. But due to how the code works on creating the PDF pages, the only way I know of is to extract the elements of the array one by one. Unless, I guess, I somehow created several different datatables or something to span across the several PDF pages, but I would be confused on how to even go about that. I 'could' use something else other than an array to store the numbers, but just not sure what would be best here.
Any other suggestions? Thanks.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former." - Albert Einstein
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
™