Pgmer

Ckeck the i value when ur deleting. i think it will be allways zero. as u have declared dim i as integer but never assigned the value to it. Problably if u remove first item it is working.

If i have understood your query properly then ur talking about the intelisence in Visual studio. Everything is object of class.. for example textbox is a class and it is having methods,functions, properties etc... So when Microsoftt release new framework or updates. it adds the new behaviour to these classes …

Is ID column is primary key or do you have constraint? Is the ID column is set to autoincrement?

u mean to say u want to reverse?

Can you please give us the further details like when ur getting this error?

It has not got installed properly or try restart ur system.

If only few values, We can save in Application setting files?

based on the condition take the cell of the row and set to true.

you can't show messegebox in asp.net. you can do that in javascript using Alertbox.

what is the textbox.text? any this is there in textbox when this piece of code runs?

Loop through data reader and get the items you want to assign to list box else get the result into dataset and then assign the dataset as datasource to ur listbox.

Ur application does only search? or any other pages are there? If only Search page you can write the code in that page. if u have mupltiple pages probably u need to go for 3 layer architecute.

Are you giving any button upon clicking u want to calculate? or on fly u want to?

Check you have permision on FTP to download the file.

it will do 2011-2010 difference is 1 right?

Hi Jemz.. No Need of combbox. for a text box there is a property called autocompleteSoruce you get all the text which u want to show in textbox when user enters a text from ur databse and bind it. and set the proprty autocompletemode of text box, APPEND,SUGGEST.. whatever u …

In database you want to achive?

Hi All, I have column which consist of data like AB1 AB2 AC3 AD5 AB1 AB2 When i do order by this coulumn, its not ordering properly. It should order like AB1 AB1 AB2 AB2 AC3 AD5 Thanks

you need to pass the index of array element to remove. and in loop if u do it u will get error saying index out side the bounds of array, as element is deleted.

What is the field in database? and Call_Date is datetime datatye? it should be datetime. and instead of passing it as parameter u can use system.datetime.now.

Before running the execute query statement, take the select statement and try to run in DB so u will come to know where and what is missing...

[CODE] Dim resultdate As Long resultdate = DateDiff(DateInterval.Year, date2, date1)[/CODE] Try this...

100 record is not bulk for sql..

[CODE]TextBox1.Text = DropdownListBox1.Selectedtext.ToString[/CODE] or [CODE]TextBox1.Text = DropdownListBox1.Text.ToString[/CODE] try these two..

right click on a file and use "open with..." to open it with my program. How can I do it? For this you need to install your application in the system. then you could see your application in the selection list.

Hi, This is the code given by [B]debasis[/B] das in this forum for some one. See if this can help you.. [CODE] Public Function NumToWord(ByVal numstr As Object) As String Dim newstr As String Dim tempstr As String = "" numstr = CDec(numstr) If numstr = 0 Then NumToWord = …

U want to open in webbrowser? or u want to show the webpage in winform?.

Hi All, Can anyone throw idea to make the form as Resolution Independent? Thanks..

Maonths.Add function u have to use

Could you please explain in detail? What you mean by not fecthing data from server? Any error?

Ur playing with grid without binding any records to it.:) u myt be getting error if im right. first bind records before u start playing with grid...

Ur talking about two things here, Writing insert,update,delete query in class and stored procedure. both are differnt. you mean to say writing seperate class for handling database transactions?

If you publish your application also code can be viewed using reflector. So you need to Obfuscation of code.. Look into this link for more info [URL="http://www.dotnetspider.com/resources/664-What-Obfuscation.aspx"]http://www.dotnetspider.com/resources/664-What-Obfuscation.aspx[/URL]

In vb.net also for textbox there is a property called MAXLength u can set the length there..

Write property in your class which sets or gets the Connection string. which should be public. and create the instance of this class in the form where you want to set the connection string from textbox and access the proprty and set it. Exapmle.. [CODE] Dim M_connstring as string Public …

Try using Ajax update panel.. Only the controls which all are in ajax panel will get refreshed rather the complete page..

In combobox selected index changed event get the selected item and set it to textbox

Get the input from the user, If your using SQL server u can use fulltext index serach functionality. It will serch in table u mentioned for the words u pass and gives the result set.

which database ur using?

Drag and drop the gridview on ur page. it will write some code in the designer. read that code, and next time u write the code dont drag.:) Assign the dataset to gridview as source wherever u want to.

Are your files are in debug folders when you build ur application? in debug mode can u check?

Use output parameters.. like declare @result int @result output. In ADO.net method also u need to have one variable of same data type. and u have to use parameter.direcection method.

[CODE] If System.IO.File.Exists("Your file path") = True Then ' File exist do what you want Else Messagebox.show("File does not exists") End If [/CODE] The above code is vb.net syntax to check the file exist or not in specific location. may be simillar function may exist in vb6 also.

Use split function and get only ABC-01

Hi All, [CODE] SELECT 'Name A ' as Column0, Some column as Column2, FROM MyTable WHERE my condition UNION SELECT 'Name B' as Column0, Some other column as Column2, FROM MyTable WHERE my condition [/CODE] I want to concatenate the rowNumber with column0 any idea how to do that? Thanks …

you mean u want to verify the row already exist or not in SQL? IF not exist u want insert if exist dont insert?

[CODE] Dim userString as string dim ActualString as string="123abc" userString =textbox1.text If userstring=actualstring then messagebox.show("String Found") Else messagebox.show("String not Found") End IF [/CODE]

DataGridView1.Rows.RemoveAt(DataGridView1.CurrentRow.Index)

Hi All, I have two dimentional array, i want to filter the records in array is there any way to do it?

Hi adata post can he use Hiden Fileds also?