txtCCMail = row.Cells(7).Controls(0).FindControl("ccTextBox") txtBCCMail = row.Cells(9).Controls(0).FindControl("bccTextBox")

On RowDataBound event set some Id value to HiddenField in each row. And then on the button click event you can check for the hiddenField's value and then take appropriate action, meant particularly for that row.

If you set this property at design-time, then run your app, of course this is going to be displayed before you bind the grid to a dataset. Set the property only after you do a fetch and return no, or incomplete, results. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

If you want to update existing records, use UPDATE[^] statement, not INSERT. The need to optimize rises from a bad design. My articles[^]

Basically you need to join those tables and then group by ModelName and RegionCode but to get this statement further: what is the relationship between those four tables? Your query should look something like: SELECT SRO_ModelMaster.ModelName, cmp_RegionMaster.RegionCode, Count(*) as 'TOT' FROM SRO_SurveySelectedModel, cmp_RegionMaster, SRO_ModelMaster, SRO_ROMaster WHERE ???.modelno = SRO_ModelMaster.ModelNo AND SRO_ModelMaster.ModelName='FNRO' AND ???.approved='Y' AND ???.RosapCode = SRO_ROMaster.ROsapCode AND SRO_ROMaster.region='ER' AND SRO_ROMaster.??? = ???.??? GROUP BY SRO_ModelMaster.ModelName, cmp_RegionMaster.RegionCode The need to optimize rises from a bad design. My articles[^]

hi, u can use the tag that will help u check this http://www.webdeveloper.com/forum/showthread.php?t=142852\[^\] regards koolprasad2003:rose: If the message is useful for U then please Rate This message... Be a good listener...Because Opprtunity knoughts softly...N-Joy

Set the Datamember and valuemember property of the combobox.

Be warned, if there are large volumes of data using the SELECT INTO method could lock all other processes out as it locks the system tables (such as syscolumns, sysobjects etc) for the duration of the select. It is much better to do it in two steps: SELECT * INTO new_table FROM old_table WHERE 1 = 2 -- creates the new table INSERT INTO new_table SELECT * FROM old_table -- populate it Bob Ashfield Consultants Ltd

If you're using the GAC, you probably want to ask in the right forum ( ASP.NET ). Active X dlls don't live in the GAC, they are totally different concepts that have nothing to do with each other. Christian Graus Please read this if you don't understand the answer I've given you "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 )

soniasan wrote: So will it possible to write the functionalty through Web Services. It's not possible like you described, IF I understood your description. Web Services exist for a very short time and do not hold session state. What you're decribing requires a very long object lifetime and maintain session. This would be better served by either a Windows Service or directly in your application. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

soniasan wrote: Command.Parameters.Add("@DOB", SqlDbType.DateTime, 50).Value = Format(dtpCustDOB.Value, "YYYY-MM-DD") i am getting "Failed to convert parameter value from a String to a DateTime The errors suggests that you pass a DateTime object. So, why are you converting the DateTime object the Date Time picker gave you in to a string first? Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

Hi, first of all, you have a Datagridview which is databound(), then you manually add data and after that you click a button. What should this button do? Just refresh() the data in the grid? The grid is attached to a dataset, the dataset should acceptchanges() from the datagridview. ohterwise the original dataset is shown. After the dataset is refreshed, should the added data be stored in the database?

Arr You Using VB6 or Visual Basic .net but in both cases there is only a single form so no matter you are working on which ever tab of tab control you could use the datetimepicker's value change to calculate the age. and store into the textbox you required. With Regards Yogesh Agarwal modified on Friday, February 29, 2008 5:45 AM

Here are some forums I used when dealing with combobox's in a grid. Maybe they will help you. If not, I suggest searching the articles for help. http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.windowsforms/topic53854.aspx[^] http://www.vbforums.com/showthread.php?t=465732[^] Good luck!

use the cell click event to identify the cell and set the text property of the textbox to the cell value TextBox1.text = sender.value

Hi, soniasan wrote: sqlcommand1.ExecuteNonQuery() comment the above line and try to execute the code... Regards, Sandeep Kumar.V

hi man Number one try to change you Procedure to be like this, you have Complicated things in your Procedure, remember the order of declaration is important in your Procedure Create Procedure usp_OutBound_Login_Details ( @Agent_ID BIGINT , @Extno VARCHAR(50), @LoginDateTime AS DATETIME, @IPAddress VARCHAR(50) = 0 ) as Insert into OutBound_Login_Details With(RowLock) (Agent_ID , ExtNo,Login_Time,IPAddress) Values( @Agent_ID,@Extno,Getdate(),@IPAddress) SELECT Outbound_Login_ID FROM Outbound_Login_Details (NOLOCK) WHERE Agent_ID = @Agent_ID And Login_Time = Getdate() AND Extno = @ExtNo number two your Procedure Expect Parameters and you did not supply them from your Sub, i see that you are supplying values but where does those values come from? do they fly into the Sub from nowhere ? number three you have Declared a variable "@IPAddress" and initialized it to 0, and now your procedure that you are calling from your vb code need that parameter and you did not supply it. Why dont you make an IP address a default value of "0" and dont include it in your Procedure, see how i got rid of the @LoginDateTime variable, you are wasting resouce's. And in your Procedure does not tell us that you want to receive an Output from this Procedure, we only see your intensions in your vb code.You have done a lot of mistakes both in vb and in SQL. i suggest you Google and try step by step to spent time on your Procedure and after that you will know that you want to receive an output from a Procedure, remember to put output keyword when you declare a variable to will carry an output for you.In your vb.net code be in mind that you are supposed supply an input make sure that you show us how you get those inputs after that you must come back and show us what you did. Dont worry i learnt from Dave and Colin that is why am like this hope it helps Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za

Try with windows registry methods such as GetFromRegistry and SetRegistry so to retain the default values. Sabarinathan T, India. The interests are to know something about everything and everything about something...

Write it on textbox_textchanged() event if text1.text="B" then text1.text="B.E"