sierrainfo

Do you want to generate sequential IDs--1,2,3, etc.

A simple code on how to connect sql server from VB.Net via SQL connection string, and the use of [B]ExecuteNonQuery()[/B] method to execute the command and the try and catch to catch errors during runtime. Example information: [B]SQL data:[/B] Database name: user Table name: user_t Columns: user_id,lname,fname,username,password,usertype [B]Controls: [/B] [B]textboxes: …

See the reference link : [url]http://support.microsoft.com/kb/308825[/url]

[url]http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx[/url]

u can also use CheckedListBox control. see the following link. I hope it will help u. [url]http://msdn.microsoft.com/en-us/library/2yc9d57t.aspx[/url]

try this in the Load event, it should solve your problem: [code=ASP]protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Clear(); DropDownList3.Items.Add("BE"); DropDownList3.Items.Add("Drawing"); DropDownList3.Items.Add("PG"); } }[/code] Regards Sunil Punjabi <URL Snipped>

I hope this helps: The Microsoft provider ships with the .NET Framework 1.1. All types are contained in the System.Data.OracleClient namespace. The Microsoft provider requires Oracle client version 8.1.7 or above. ODP.NET is freely available from the Oracle Technology Network (OTN) at [url]http://www.oracle.com/technology/software/tech/windows/odpnet/index.html[/url]. The types are contained in two namespaces—Oracle.DataAccess.Client …

You can use MsgBox -- just like in VB6.

try this [COde=sql]SELECT Tel_H_Code + ' ' + Tel_H AS Tel_H FROM Detailed_List[/COde]

Try to following links. I hope it will help u. [url]http://www.programmingtutorials.com/vbnet.aspx[/url] [url]http://www.java2s.com/Code/VB/CatalogVB.htm[/url] [url]http://download.microsoft.com/download/8/e/7/8e725d96-7ec3-498b-9fa7-86779aed101f/dotNET%20Tutorial%20for%20Beginners.pdf[/url]

heres the sample code you can use from MSDN: [url]http://support.microsoft.com/kb/306125[/url]

hope it will help u. [url]http://www.dotnetcurry.com/ShowArticle.aspx?ID=109&AspxAutoDetectCookieSupport=1[/url] [url]http://www.codeproject.com/KB/aspnet/ASPXFILES.aspx[/url]

[code] Imports System.Data Module Test Sub Main() Dim sConnectionString, sSQL As String 'SQL Connection String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb" sSQL = "SELECT Title FROM yourTable" Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString) Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn) Dim dr As System.Data.OleDb.OleDbDataReader conn.Open() dr = cmd.ExecuteReader() Do While dr.Read() System.Console.WriteLine(dr.Item("Title")) Loop dr.Close() …

Declare public variable in a Module. Store the radiobutton value in the variable and then retrieve the value stored in the public variable in the main form.

Can you please explain a bit more of what exactly you mean by "attach" to SQL Server.

Try the following Steps : [B]Go to the folder C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG Select the Machine.config and then find the tag <DbProviderFactories> under <system.data>.Then next step is to hide all the provider entries which has either Version=3.5.0.0 or Version=9.0.242.0. [/B] [QUOTE] <DbProviderFactories> <add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" …

hi see the following links. I hope it will help u. [url]http://www.codeproject.com/KB/books/0764549146_8.aspx[/url] [url]http://www.codeproject.com/KB/recipes/IE7_Clone_VS2005_Browser.aspx[/url]

see the link to solve your problem : [url]http://www.pin5i.com/showtopic-7166.html[/url]

hope it will help you. [url]http://www.15seconds.com/issue/060323.htm[/url] [url]http://www.c-sharpcorner.com/UploadFile/raj1979/GridViewExample11232008075052AM/GridViewExample.aspx[/url]

[QUOTE] [B] 1st Method[/B] Imports System.Data Module Test Sub Main() Dim sConnectionString, sSQL As String 'SQL Connection String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\yourdatabase.mdb" sSQL = "SELECT Title FROM yourTable" Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString) Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn) Dim dr As System.Data.OleDb.OleDbDataReader conn.Open() dr = cmd.ExecuteReader() Do While dr.Read() …

[url]http://www.daniweb.com/forums/thread117895.html[/url]

Try this links [url]http://faqfront.com/document/sql-server-session-state[/url] [url]http://en.csharp-online.net/ASP.NET_State_Management%E2%80%94Storing_Session_State_out_of_Process[/url] [url]http://www.codeproject.com/KB/session/ASPNETSessionInternals.aspx[/url]

Hope it will help you. [url]http://aspalliance.com/1479_Using_XSLT_to_Transform_XML_Using_ASPNET.all[/url] [url]http://www.geekinterview.com/question_details/44257[/url]

hope it will help you [url]http://vbdotnetforum.com/index.php?showtopic=1022[/url]

[COLOR="Green"]SELECT DISTINCT(MobileNumber), COUNT(MobileNumber) AS RecordCount FROM MobileTable GROUP BY MobileNumber[/COLOR]

In Form1 Private Sub CustemersList_DblClick() Form2.Comand1_Click() End Sub In Form2 [COLOR="Red"][B]Public[/B][/COLOR] Sub Command1_Click() 'Your Code Here End Sub If you got it [B]MARKED AS SOLVED[/B]

[url]http://en.wikibooks.org/wiki/Active_Server_Pages/Differences_between_ASP_3.0_and_ASP.NET[/url] [url]http://www.techiwarehouse.com/cms/engine.php?page_id=61d8b135[/url] [url]http://www.tutorial-web.com/asp.net/[/url] [url]http://www.w3schools.com/aspnet/aspnet_vsasp.asp[/url]

[url]http://www.devasp.net/net/articles/display/265.html[/url]

Try this following links. Hope it will help you. [url]http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx[/url] [url]http://www.dotnetspider.com/resources/15591-How-read-EXCEL-data-file-asp-net.aspx[/url]

Try this : [COLOR="Red"]Go to Control Panel >>>> Regional Options >>> Numbers and change the "Digit Grouping" like 12,34,56,789 then OK [/COLOR] [COLOR="Green"]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = Format(Your No., "##,##0") End Sub[/COLOR]

[url]http://www.c-sharpcorner.com/UploadFile/mamtam/AddandRetrieveImages09232005080918AM/AddandRetrieveImages.aspx[/url] [url]http://www.vbdotnetheaven.com/UploadFile/scottlysle/ImageToSqlServer11242006025136AM/ImageToSqlServer.aspx[/url]

Hope it will help u. [url]http://www.aspnettutorials.com/tutorials/database/Save-Img-ToDB-VB.aspx[/url] [url]http://forums.asp.net/p/739822/996518.aspx[/url]

see the links. [url]http://www.codeproject.com/KB/vb/VB2005_SMTP_EMail.aspx[/url] [url]http://www.aspnettutorials.com/tutorials/email/email-aspnet2-vb.aspx[/url]

u can use Hierarchical FlexGrid or FlexGrid control to display the data. See the following link for example. [url]http://kbalertz.com/223073/MSHFlexGrid-Invalid.aspx[/url]

See the following links. Hope it will help you. [url]http://systems.bus.ucf.edu/lwest/courses/4212/lessons/reports.htm[/url] [url]http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx[/url]

see the following link [url]http://forum.cheatengine.org/viewtopic.php?p=2018703[/url] [url]http://vbcity.com/forums/faq.asp?fid=6&cat=Forms[/url]

[url]http://www.aspnettutorials.com/tutorials/database/db-repeater-aspnet2-vb.aspx[/url] [url]http://www.devasp.net/net/articles/display/663.html[/url]

see the link [url]http://www.west-wind.com/WebLog/posts/1646.aspx[/url]

Hope it will help you. [url]http://www.tek-tips.com/faqs.cfm?fid=3940[/url]

[url]http://asp-net-whidbey.blogspot.com/2006/04/generating-pdf-files-with-itextsharp.html[/url] [url]http://www.developerfusion.com/code/5682/create-pdf-files-on-fly-in-c/[/url] hope it will help u

Please clarify, values are sum or count or any other.

See the following links for details : [url]http://www.builderau.com.au/program/windows/soa/Reading-and-writing-text-files-with-VB-NET/0,339024644,320267367,00.htm[/url] [url]http://www.astahost.com/info.php/text-file-operations-vb-net_t6372.html[/url]

[B]Public Class Form1[/B] [COLOR="Green"] Dim firstchoice As Double Dim secondchoice As Double Dim buttonnumber As Integer Dim HasCalcDone As Boolean[/COLOR] [B]Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click[/B] Dim buttonnumber As Integer = 1 If lblFirstNumber.Text = String.Empty Then lblFirstNumber.Text = buttonnumber firstchoice = buttonnumber Else …

[url]http://msdn.microsoft.com/en-us/library/bb426882.aspx[/url]

[url]http://www.go4expert.com/forums/showthread.php?p=37348[/url] [url]http://www.dreamincode.net/forums/showtopic70247.htm[/url]

See the following links. Hope it will help u. [url]http://www.codeproject.com/KB/aspnet/EmailApplication.aspx[/url] [url]http://www.learnxpress.com/modules/contents/channels/prog_aspnet_2_email.aspx[/url] [url]http://aspnet101.com/aspnet101/tutorials.aspx?id=52[/url] [url]http://www.codeproject.com/KB/aspnet/Send_Emails_in_ASPNET20.aspx[/url] [url]http://www.dotnetcurry.com/ShowArticle.aspx?ID=65&AspxAutoDetectCookieSupport=1[/url]

[url]http://vbcity.com/forums/topic.asp?tid=64171[/url] [url]http://stackoverflow.com/questions/229404/ignored-columns-using-vb6-to-extract-from-excel[/url]

See the following links. I hope it will help u. [url]http://www.codeproject.com/KB/aspnet/webconfig.aspx[/url] [url]http://www.asp.net/Learn/data-access/tutorial-73-vb.aspx[/url] [url]http://aspnet.4guysfromrolla.com/articles/021506-1.aspx[/url]

[url]http://www.codeproject.com/KB/aspnet/HTML2PDF.aspx[/url]

[url]http://www.a1vbcode.com/snippet-4135.asp[/url] [url]http://www.developerfusion.com/forum/thread/28348/[/url] [url]http://www.eggheadcafe.com/community/aspnet/8/10009179/set-parameter-values-to-c.aspx[/url] I hope it will help u.