babbu

i want to call the load event of the form inside the click event of the commant button depending upon certain condition how can i do this?

wht is the error tht u r geting

you could also use a data reader to store the result. [code] datareader = cmd.executereader(); while(datareader.read) { cmb.items.add(datareader.getValue(0)); } [/code]

what exactly are you trying to do. The fact that it is in the overflow exception means it has exceeded its available limit. changing the datatype here won't help since the variable "result" is created inside "Factor".

Firstly you should be using a parameterized query. Do a quick search on that and you'll know how its used. Coming back to the issue at hand. step 1: enter employee name in text box and then hit the search button step 2: Populate a label to display the current …

Hi, My project is in c#, created in vs2008 with access 2007 as the db and windows 8.1 as the os. I've created a setup file with the required dll and accdb file added to it. When the application runs for the first time it creates another copy of the …

yes you can use or operator select * from employee where id = 10 or name = 'ankit'

I have created an application in c#. Following are my concerns. 1) create setup file which includes the ms access db 2) identify the location where this db will be stored 3) use this location as the data source for the application

m getting the same error. i have vista installed on my pc (if tht makes any difference). some microsoft support sites recommend changes in the registry but i couldnt find those files in the registry. i tried insatalllin office again but all in vain. plz help

hie how can i restrict the user to enter only numbers in a textbox

hie m using visual studio 2005 and sql 2005 i want to export my sql database to excel..

what r u trying to do..? do u want the user to enter only numeric values?

Is it possible to trigger an informatica job in JSP/Servlets? For eg. in unix we use pmcmd command to perform this task. Is it possible to run informatica jobs in JSP/Servlets?

Hi, I have a JSF application. There is page parent.jsp which opens a popup using javascript (window.open() function) I want the data on the parent.jsp page to be available on the popup window as well. Any idea how this can be done. The application also uses JSF Portlets.

Hi I want to pass the data from one JSF page to another without using query string. Any idea how this can be done??

Hi I am looking to set the value of <portlet:param> tag using java script. Here is my existing code [CODE] <form name="frmname" method="post" enctype="multipart/form-data" action="<portlet:actionURL><portlet:param name="page" value="mainview"/></portlet:actionURL>"> [/CODE] And I am setting the value of the portlet:param tag by calling the following javascript on the page load event. [CODE] function …

Is is possible to create excel file with multiple workseets using response.setContentType.?

Hi, I have a code that writes data to excel using setcontentype(application/vnd.ms-excel) Now I want one of the columns to be formatted to currency. I do not intend to use any additional jars(POI, etc). Is it possible to achieve the task. Thanks

Visual studio 2005 and access 2007. Autocomplte textbox is not displaying results. Here is my code [CODE] txtname.AutoCompleteCustomSource = m_namesCollection; m_namesCollection.Clear(); if (!String.IsNullOrEmpty(txtname.Text.Trim().ToString())) { m_search = txtname.Text.Trim().ToString(); foreach (DataRow cust_dr_autoloop in m_dt_Customer.Rows) { if (cust_dr_autoloop["cust_name"].ToString().StartsWith(m_search)) { m_namesCollection.Add(cust_dr_autoloop["cust_name"].ToString()); } } } [/CODE] I have set the autocomplete mode to suggest and …

Hi textbox_Leave event is fired everytime AutoCompleteStringCollection is cleared..any ideas how I can prevent the leave event to fire while clearing AutoCompleteStringCollection

Hi, I am using vs 05 and access 07. I would like to export the data in the datagrid to an excel file preferably in excel 2007(i.e. .xlsx). I have found this discussion on daniweb [url]http://www.daniweb.com/forums/thread211651.html[/url] however i get an error [CODE] Excel.Application app = new Excel.Application(); [/CODE] Am i …

Hi, I am trying to run sql command on unix. this results in the following error "sqlplus: not found" Here is the unix part [CODE] sqlplus id/pass@some_server.com<<eof select sysdate from dual; exit eof [/CODE] The database is on a remote server and. Do I need to enter all the tns …

Is running an update query better or making changes in a datatable and updating them later a better option. And how do we determine which is the better option?

I am using Visual studio 2005 and Access 2007. I get the following error "System.InvalidOperationExceptin: The ITransactionLocal interface is not supported by the 'Microsoft.ACE.OLedb.12.0' provider." Is this because transactions are not supported by access? Here is my code. [CODE] using (TransactionScope TransacScope = new TransactionScope()) { //insert and update operations …

Hi I want to convert System date into desired format before displaying it to the user. For eg. The system date might be in mm/dd/yy format and I want to display it in dd/mm/yy format and vice-versa. Please help me in figuring this out.

On the click event of the button you can capture the data and clear it. For eg. [CODE] c1 = Textbox1.text; Textbox1.clear(); [/CODE]

Hi, In JSP for some responses from the server the header is null. Is this because the header size becomes very large? If yes then is there a possibility wherein we can increase the size of the header? What is the maximum possible size limit? I am using JSP and …

Hi All, I am using visual studio 2005 and Access 2007. I want to update a table in access 2007 using C#.net. I have written the following code but it doesn't seem to work and neither does it throw any error. [CODE] OleDbCommand updateTransactionCost = new OleDbCommand(); updateTransactionCost.Connection = Module1.oledbcon; …

You can do one more thing Set all the controls disabled by default Set a global boolean variable which will help u determine which button is calling the form and while the form loads you can check value of the boolean variable and accordingly enable the controls

u can put the code in the same forms....

hie, i have a web project made in jsp in one of the jsp files there is this statement [code] parent.metric.location.replace() [/code] and some values inside the parentheses. please explain what this method does.[code][/code]

u said u want to change the color every half second so you could do the following [code] private void Form1_Load(object sender, EventArgs e) { timer1.Enabled = true; timer1.Interval = 500; timer1.Start(); } private void timer1_Tick(object sender, EventArgs e) { if (BackColor == Color.Red) { BackColor = Color.Blue; } else …

[code] delete * from tablename where primarykeyvalue = value [/code]

[code] SELECT * FROM INFORMATION_SCHEMA.Tables WHERE Table_Catalog = 'myDatabase' [/code] i googled your query and came up with this solution. Sorry couldn't verify it cause i do not have access to a database at this moment

[QUOTE=;][/QUOTE] [code] delete * from tablename where primarykeyname = valuetobedeleted [/code]

[QUOTE=;][/QUOTE] well if you want to insert values try this [code] c[i]="hello"; [/code] or if you are trying to get the value from the user try this [code] Scanner c = new Scanner(System.in) c[i]=c.nextXXX();//xxx can be replaced with any datatype like int, String etc... [/code]

[QUOTE=;][/QUOTE] try this code [code] break A: [/code]

try datagridview

or you could write the try catch inside the for loop as well. m not sure whether this is good programming practice.

[code] Form26 f26 = new Form26(); f26.show(); [/code]

I am using access 07 and c#.net 2005. I have a datagridview which has one combo box column. I want to insert values in the combo box. however the value of combo box in each row will be different. [CODE] comboboxcolumnname.Items.Add(value) [/CODE] using this code i can add values to …

are you using a 64 bit operating system. which version of access are you using

hie all i have a fujitso seimens amilo Li 2735. ive configured netgear wifi router. but m unable to connect my laptop to the wifi. i have windows 7 installed. i tried to trouble shoot. it tells me turn on wireless capability. i tried turning it on (Fn + F1). …

u said the only change tht u have made is the name of the column in ur database. i hope u have also changed the name of the column in your code as well.. for example in the insert query u shud change the name of the corresponding column name …

m using ms access and c# i fetch the data frm the database which includes sr.no. and store in a data table. i thn display the contents using a datagridview. everythin is working fine.. heres the catch i do not want to display the sr.no...how can i make tht particular …

option = Console.ReadLine();

use the cell click event

m using visual studio 2005 and sql server 2005. i want to create a backup of the sql server which m doin using the following code.. [CODE] if (saveBackupDialog.ShowDialog() == DialogResult.OK) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"backup database dbname to disk =@loc with init,stats=10"; cmd.Parameters.Add("@loc", SqlDbType.VarChar); cmd.Parameters["@loc"].Value …

hie lennie.. i have visual studio 2005 and the code works fine. not sure about visual 2003 but u can still giv it a try... [CODE] textbox1.text = dataGridView1.Rows[dataGridview1.CurrentRow].Cells[columnindex].Value.toString(); [/CODE] more over u r nt suppose to paste text between code tags only the code between code tags

first add a check box column to the datagridview. to do this click on the datagridview control on ur form. click on the right arrow on the top of ur datagrid. click edit columns add a column and set its type to check box column [code] private void dataGridView1_CellClick(object sender, …