|
Try the following code written in VB.NET
<br />
Dim myConnection As New SqlConnection("server=localhost;Trusted_Connection=true;database=Portal")<br />
Dim myCommand As New SqlDataAdapter("select * from Portal_Events", myConnection)<br />
Dim ds As New DataSet<br />
<br />
myCommand.Fill(ds, "Portal_Events")<br />
ds.Tables("Portal_Events").Columns.Add(New DataColumn("New Column1"))<br />
ds.Tables("Portal_Events").Columns.Add(New DataColumn("New Column2"))<br />
DataGrid1.DataSource = ds<br />
DataGrid1 object must be created before using this code. Create it by drag n drop from Toolbar in Visual Studio Development Environment.
Change the connection string and sql command according to your needs.
|
|
|
|
|
Hi,
i have a main WebUserControl that is the main view of my website,the problem is that i have other Many WebUserControl that i wnt to add in my main WebUserControl how can i add this in my One Main WebUserControl?bcz i dont wnt to make the main WebUserControl again and again and call the SubWebUserControl accrodingly to my main control.
Tell me the Proper way of Calling or Emedding the SubWebUserControl in my Main WebUserControl..
send me some codesnippet if possible?
waiting ?
|
|
|
|
|
i want to diplay the name of text file in a directory as a hyperlink and when i click the hyperlink the the file should be read in a page. how could i do this.
|
|
|
|
|
HI all! I've 5 different projects inside a solution. My problem is I've to fina a way to have a dll stored only in one project and use this dll in other projects. But visual studio does not seem to find the path. I tried every possible way like "/Project1/Folder1" , "../Project1/Folder1" , "./Project1/Folder1". Otherwise a lot of space is wasted by keeping the copy of the same dll. Anyone have any other idea?
Thanks in advance
Don't Quit
|
|
|
|
|
Create a solution and add the projects in one at a time. Then create refercnces to the projects you wish to access from other projects. VS will automatically build it in the correct order.
Its only hard the first time.
Blog Have I http:\\www.frankkerrigan.com
|
|
|
|
|
Hi! in my asp.net application i want to calculate time interval for a folder i.g. [
TimeOut - TimeIn]. for this this purpose i store its TimeIn in a varaible, & after completing tasks on that folder i aslo store TimeOut in a variable when a user clicked on the exit button. my proble is that suppose that user closes browser using cross button of the browser instead of clicking exit button. in this case how can i calculate TimeOut?
|
|
|
|
|
I have 3 TextBoxes which hold Addresses.
Only if all the three textBoxes are blank i need to display a Message saying, Address cant be left blank.
Even if any one of the textBox is filled i should not display the message.
I have to do this in the client side and then on the click of a button i need to validate the address(i call a function in the code behind page in C# to check the format)
Please help me. How do i go abt? 
Mads
|
|
|
|
|
I not so sure about how to accomplish this task with required field validator but you can use javascript code for this purpose. Custom validator can serve the purpose.
Best Regards,
Apurva Kaushal
|
|
|
|
|
hi all,
please can anyone tell me what is arraylist conept in .net and how it is differ from Array?
thanks,
Rahi
If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
You can get it here[^] .
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi everyone,
I'm currently working on an ASP.NET project where I'm required to insert some data into a db. This part is fine, but I'm having trouble when the page loads again after an insert. It seems the page needs to be loaded twice for the inserted data to appear (presumably because the data is inserting on the first page load).
Is there anyway I can get the page to refresh after the insertion so that the data appears? I know in php you can do header("Location: ...") to do this, but is there an equivalent or better approach for asp.net? I'd like to maintain state if I can. I can't seem to find anything in MSDN of use.
Any help or pointers would be great,
Thanks!
|
|
|
|
|
How are you displaying the data in the page, if you are using datagrid then you just need to rebind the datagrid after you insert the record in the database.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I'm using a formview, but the data I'm concerned with is not bound as it consists of multiple records from a different table than the one I'm using for the rest of the data.
I have a function to select this data and format it nicely (it's a list of user posted messages). I'm trying to get it to appear right away after an insert.
|
|
|
|
|
Hai,
I got a doubt regarding Comparsion of user data on the webform with database records. i developed a webform where the user needs to submit data regarding request for software license. In this form there is field regarding request for license transfer. If the user selects 'yes' should search for olddatabase records with data entered on the form. If the data entered is old system data (with comaprsion of database records), i should prompt user to select for the new data.if the user enters new system data, i should prompt user to enter the old data. i am able to retrieve the data records with SQL queries. after reading that data with data reader how to compare the data records and user data.
Thank you,
veerendra
|
|
|
|
|
Once the data is there with you, it is as simple as to compare a string value provided if I am understanding your problem correctly.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hello guys,
I was wondering if someone could tell me how to assign an alt attribute to a or element. It doesn’t show up under these two elements. I have a text box but before that is a span which is used in place of a label and it says type in your e-mail. Now I want the alt (alternative text) attribute to be active on this span element. How do I do that. Please help.
Thanks
Tina
|
|
|
|
|
Putting a title attribute on it will generate a tooltip in most browsers.
Using the GridView is like trying to explain to someone else how to move a third person's hands in order to tie your shoelaces for you.
-Chris Maunder
|
|
|
|
|
Thank you so much Andy, it worked for input type = text (text box) and for span also.
Thanks
Tina
|
|
|
|
|
Those elements doesn't have an alternative text. Only images have alternative text, which is used if the image can not be loaded or displayed.
What you are looking for is the title attribute.
---
It's amazing to see how much work some people will go through just to avoid a little bit of work.
|
|
|
|
|
Thaks Guffa, yup that's what it was.
Thanks
Tina
|
|
|
|
|
hi friends
objdatareader=objcommand.executereader(commandbehavior.closeconnection)
regards
saravanan
|
|
|
|
|
Hi, I am creating a forum type. This forum consists of many sub forums in it for example: Computers, Gadgets, Music etc.... Users will login to use this forum for their own use of trading objects and bidding on object. The problems I am facing right now that I don't know are these:
1. I know how to make a datagrid with pages (After 10 post it creates another page) .. but I don't know how to access the second page of that datagrid. Can anyone help me in this pls?
2. How to upload pictures into asp.net using Ms Access Microsoft not sql.
3. How to make links from a datagrid (each row has a link) to a specific page. How can I make this happen because i dont know how to grab a specific link that the user chose.
Help me in this pls!! Thanks alot for any feedback 
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
solutions:
1. in the datagrid set PagerStyle for the type of pagination.
write an event handler for PageIndexChanged event. if your datagrid id is dg then the code will be something like this
<br />
private void dg_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)<br />
{<br />
dg.CurrentPageIndex = e.NewPageIndex;<br />
}<br />
2. I cannot understand your question. If your question is related to uploading file to webserver, you can use <input type="file" /> and then use the SaveAs method of HttpPostedFile.
3. you can use HyperlinkColumn in the datagrid, or use a <a> in a TemplateColumn.
Hope this information will suffice your need.
Thanks,
Pradipta Basu
|
|
|
|
|
Hi Pradipta,
Thanks for your help man. I have some questions to ask please. For my first answer you told me .. "dg.CurrentPageIndex = e.NewPageIndex;" .. what is the NewPageIndex Please?? because when I made e. .. the only thing there was is getType.
Second question is for the pictures. I need to make the users to upload their picture on my forum. I am using an MS Access 2003 not SQL. I dont know how make this happen. I dont know where can I begin with thats why?
Third question .. I want a datagrid that will show the details of the object the users signed in. I want a hyperlink within every row. This link directs the users into a page with more details about that specific row (object). How can i make this please?
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
1. look here, when the pagination is on, it comes in number format, like 1,2,3,... or in Previous/Next format.
consider the previous next format. when you are in page 5, and click next, the next page index is 6. so e.NewPageIndex = 6.
2. I will prefer to keep the images in a folder in the webserver, and keep the path of the images in database. This is done the way I have told in my previous mail.
3. Lets say your object id is objid in the database and you are binding the datagrid with a datatable which get filled from the database table of objects.
Now the column will be something like this
<br />
<asp:TemplateColumn HeaderText="Object ID" Visible="False"><br /><br />
<ItemTemplate><br /><br />
<a id="lnkID" runat="server" href='Newpage.aspx?id=<%# DataBinder.Eval (Container.DataItem, "ID") %>'>><%# DataBinder.Eval (Container.DataItem, "ID") %></a><br /><br />
</ItemTemplate><br /><br />
</asp:TemplateColumn><br /><br />
For more on datagrids, read my article
How to create the id of <td> and <tr> generated by DataGrid in ASP.NET and use it by client-side JavaScript.
Hope this will do.
Pradipta Basu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
