pritesh2010

try this code for which i had done in my computer i'm using textbox you can use any thing as per you want[CODE] private void BindGrid(int rowcount) { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new System.Data.DataColumn("TextBox1Column", typeof(String))); dt.Columns.Add(new System.Data.DataColumn("TextBox2Column", typeof(String))); dt.Columns.Add(new System.Data.DataColumn("TextBox3Column", typeof(String))); if (ViewState["CurrentData"] != null) { for …

very finny and solution is also very for this try keydown event[CODE] Private Sub ComboBox1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles ComboBox1.KeyDown If e.KeyCode = Keys.Enter Then ComboBox1.Items.Add(ComboBox1.Text) ComboBox1.Text = "" End If End Sub[/CODE]

see this link will help you [URL="http://www.codeproject.com/KB/list/ListView_DataBinding.aspx"]Codeproject[/URL]

yse you can do this by using MDIParent1.Label1.Text = TextBox1.Text this on button click event

just wirte this query SELECT * INTO NewTable FROM OldTable your oldtable data will be copy in newtable.which will create when you fire this query. mark this thread as solved

can you tell us in brif abt your question and what is OMCustomerPSI.GetPSI

just fire this quesry you will get the data from which date you want [CODE] Select * INTO databaseB.dbo.table1 from databaseA.dbo.table2 where Date='my condition' [/CODE] where dbo is my schemaname database B is my new Database database A is my old Database table1 is create new table in DatabaseB table2 …

hello experties in my webpage i have one datagrid in datagrid i'm showing all the data.for eg date/name Title 7/14/2010 Pqrs abc gh ghfghfghh ghfghfghfg 7/15/2010 Pqrs xyz fgh fgh fgh fdg fgdfgf 7/16/2010 Pqrs lmn ytyrt yrtyrty but insted of header text like Date/Name Title i want to show …

simple solution. don't make new instance of form2. on button click write form2.Show Form2.BringTofront() if you have any parent form then write this code on that menustrip click event Form2.MdiParent = Me Form2.Show() Form2.BringToFront() try it works

huun you can a sort a column using OrderBy clause Select * from tmpls order by col1 and then you can fire a update query based on that column UPdate tmpls Set col2=1 Where col1 ='A'

ok then try to insert the with transaction. first add the refrence of transaction and then pass the query with that see this link [URL="http://www.daniweb.com/forums/thread291344.html"]Transaction[/URL]

use the System.Transaction class with your connection. for commit the transaction and rollback transaction. [CODE] Dim trans As SqlTransaction trans = con.BeginTransaction Try cmd = New SqlCommand("insert query", con, trans) ''con is a connection cmd.ExecuteNonQuery trans.Commit() MsgBox(" Number of Records inserted : " & count) Catch ex As Exception trans.Rollback() …

simple fire a query on on Radiobutton_checkedChanged event. show some code.

See this link will solve your problem for remote connection [URL="http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/"]here[/URL]

can any one help me for this code. i had created 2web page say home, employee and master page. on the mater page i want to show all the employee who are online now. for that i'm firing the query and i got the all the employee name through SqlDatareader.Now …

here is solution first amke parent form proerit IsMdiContainer=true then when you load the parent form (i.e. MDi parent form) on the load event put this code [CODE] dim f2 as new form2 //which is my form2 protected sub form1_load f2=new form2 f2.MdiParent=me //this is form1 f.show() end sub try …

I would like to suggest you to use Push [URL="http://www.beansoftware.com/ASP.NET-Tutorials/Using-Crystal-Reports.aspx"]Push[/URL] model to design [URL="http://www.codeguru.com/csharp/.net/net_general/toolsand3rdparty/article.php/c13253"]Crystal Reports[/URL].

what the silly question. on button click you are assign the value of label is 1 then how can you change it. tell me brief what you want? with some code.

see this link [URL="http://www.daniweb.com/forums/showthread.php?t=176058&highlight=how+to+check+negative+number+in+input+box+in+vb.net"]http://www.daniweb.com/forums/showthread.php?t=176058&highlight=how+to+check+negative+number+in+input+box+in+vb.net[/URL]

you are passing something wrong in command and update query.try this[CODE] "update stock set idProducto =" & campo1 & ", nombreproducto =" & campo2 & ", proveedor =" & campo3 & ", categoria =" & campo4 & ", unidad = " & campo5 & ", preciocosto =" & campo6 & …

hello everyone. can any one tell me how to delete recored from gired view dynamically. in my program i have one gridview and sqlDatasource in this i have 4 label and one button.Label shows name, date, title and description and button for delete. all this is done at source view …

what?? can you tell me in brief your question? so we can give you idea.

for show the button and hide the button you can use button visible proerty true false as you want.

for this you have to use RegularExpression class in this there is Regex class. for email vallidation see this code. using System.Text.RegularExpressions; 1)[CODE] public bool IsValidEmailAddress(string EmailAddress) { Regex regEmail = new Regex(@"^[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"); if(regEmail.IsMatch(EmailAddress)) ///in Email address write user email address return true; return false; } [/CODE] 2)[CODE] string pattern=@"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|" …

try this [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace savita { public partial class Form5 : Form { DataTable dt; DataRow dr; public Form5() { InitializeComponent(); } try { dt = hosDataSet.Tables["inpatient"]; dr = dt.NewRow(); dr["ipid"] = …

[CODE] or first you can concatinate all the first all three fileds dim str as string str=Combo1.SelectedItem & Combo2.selectedItem & textbox1.text "Select * from table Where " & str & "" [/CODE]

try this way you doing write but error is over here [CODE] "Select * from [tblSpeedStudy] Where [write codition] like/='" & ComboBox1.SelectedItem & "' and [write codition] like/='" & ComboBox2.SelectedItem & "' and [write codition] like/= '" & TextBox1.Text & "'" // when you want search then we write Select …

rty this code for login it properly works for me as i updated for you. [CODE] Dim strConn As String strConn = WebConfigurationManager.ConnectionStrings("iPesha").ConnectionString Dim Conn As New SqlConnection(strConn) Conn.Open() Dim sqlUserName As String= "SELECT UserName,Password FROM Users " cmd =new sqlCommand(sqlUserName,con) dim dr as SqldataReader dr=cmd.ExecuteReader() if dr.HasRows=true then While(dr.Read()) …

hey friend remove [CODE]Provider=SQLOLEDB.1;[/CODE]''this thing [CODE]string connstring = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=fairdealdbAnalysis;Data Source=RECEPTION\\SQLEXPRESS"; [/CODE] from your connection string . i think error is there no need to write provider

see the thread [URL="http://www.daniweb.com/forums/thread131068.html"]http://www.daniweb.com/forums/thread131068.html[/URL] it will help you

what?? i can't understand your question?you want one Datetimepicker which only select Male-Female. just tell me brief.

can any one tell me how to get the seleted submenuitem value of menu in textbox. like foe eg this is my menu Home Course -Commerce -Science i want when i select science in menu control then textbox should me the Science. any one help me i'm apppriciate. :) thank …

see this thread i had define for email validation same way you can define for your expression in regex pattern. [URL="http://www.daniweb.com/forums/thread292975.html"]http://www.daniweb.com/forums/thread292975.html[/URL]

Ok i got your problem and the solution is as follow. create your table that is Item table in tabel Itemid is Primary key and pictureId,VideoId,AudioId,CategoryId make all this column as alternate key. and after that create your other table with the name Category,Picture,Video, and audio. and alll this table …

hey why are you doing this much stuck just create a view with the join of two table and then create a index on that view then fatch the recored from the datatable using where condition. it's very simple.

hey Mitja do you have created procedure for that. first create the procedure and then write your code as per below for as per the DMl query. [CODE] SqlConnection con = new SqlConnection("");//give your connection string to open the connection con.Open(); SqlCommand cmd = new SqlCommand("proc_new_test",con);//proc_new_test is my sp name …

see this example. it will help you.

write your code on combobox_SelectedIndexChanged event

for solving this error put your connection string in web.Config file in the Configuration tab and then retrive it on the form with configuration manager. when you want to deploy project to another Computer @ that time just change the connection tring of your web.config file as per that computer …

This exaple show you how to insert image in database and how to retrive in gridview. see the attachments.

why are you writing so much of cmd it's simple for adding the data in access database see the code [CODE] Imports SYstem.Oledb dim cn as OledbConnection Dim cmd As OleDbCommand dim sqlstr as string,ans as Boolean private sub btn_click Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & "c:\Users\BELLCONSULT\Documents\LIBRARY2.mdb " …

see this link it will help u to learn how to create HTML workshop [URL="http://frogleg.mvps.org/helptechnologies/htmlhelp/hhtutorials.html#char_hhw"]http://frogleg.mvps.org/helptechnologies/htmlhelp/hhtutorials.html#char_hhw[/URL]

hello everyone i'm creating billing application in that i got the two problem while i'm use. 1)when i came in purchase form i can retrive all the supplier's name in the one genral list box list. but i want when i came in textbox for typing the name of supplier …

hello experts i got error when i running the program [CODE] " at Elactronic.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190\r\n at Elactronic.My.MyProject.MyForms.get_SplashScreen1()\r\n at Elactronic.My.MyApplication.OnCreateMainForm() in D:\\Solution SOftware\\Elactronic\\Elactronic\\My Project\\Application.Designer.vb:line 35\r\n at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()\r\n at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()\r\n at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)\r\n at Elactronic.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81\r\n at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)\r\n at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, …

hello every one. I'd created on application in vb6.0 with datareprot. I'd have to done design my biill in datareport but it create problem. it's like I'm retrieving all data from database. there is name ,address, Teleno in group header. while all the product where it will be 5 or …

hey dear when you deploye the application in any machine that machine should have .net fraemwork. then deploye it. and try it

hey You can use [CODE] The following code returns a random number: Dim num As Integer = random.Next() The following code returns a random number less than 1000. Dim num As Integer = random.Next(1000) The following code returns a random number between min and max: Private Function RandomNumber(min As Integer, …

hello everyone i'm creating one Small D.j.software.in this i got three problem 1} how to mearge one .mp3 file with onther .mp3 file 2}how to drop .mp file directly to form's list box 3} how to save that merger .mp3 file. please help

hey friend why are you doing this much coding for crystal report try I would like to suggest you to use Push model to design crystal reports.

even you can call the disk fragment like this on button click event [CODE] Dim p As New System.Diagnostics.Process p.StartInfo.FileName = "dfrg.msc" p.Start() [/CODE]