The syntax would be.... "update compiledpts set firstname='" & fname & "', lastname='" & lname & "' where contactid = 2"
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
use top and left parameter of window.open function for positioning the pop-up.like TheNewWin = window.open('','name','height=255,width=250, toolbar=no,directories=no,status=no,menubar=no, scrollbars=no,resizable=no,top=20,left=20'); This only sets the position the first time the window is opened though. If we are intending to reuse the same window for multiple popups then we will want to relocate the window to the desired location immediately after the window opens instead. use MoveTo function for that. TheNewWin = window.open('','name','height=255,width=250, toolbar=no,directories=no,status=no,menubar=no, scrollbars=no,resizable=no'); TheNewWin.moveTo(50,50);
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
you need not to include the database file in the set-up project,but you have to install the database in the machine where the application is running.......moreover if its a client-server application then install the database in the server...... and finally check for the connection string whether it is pointing to the right database in the right machine or not......
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
sorry shamaila I have forgotten that yours a windows application... then you have to make a datatable with that datareader and bind it to the datagrid.... i dont see any other option for you..
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
look at this.... http://www.thescripts.com/forum/thread175962.html[^]
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
you can use querystring with multiple parameters to pass multiple values to other page...like.... Response.Redirect(page.aspx?Orderid=" & Orderid "&ProductID=" & ProductID)
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
why are u using datareader and dataset simultaneously??? follow this... '1. Create a connection Dim myConnection as New SqlConnection( ConfigurationSettings.AppSettings("connectionString")) '2. Create the command object, passing in the SQL string Const strSQL as String = "SELECT * FROM myTable" Dim myCommand as New SqlCommand(strSQL, myConnection) 'Set the datagrid's datasource to the datareader and databind myConnection.Open() DataGrid1.DataSource = myCommand.ExecuteReader( CommandBehavior.CloseConnection) DataGrid1.DataBind() but keep in mind A datareader is a read-only object. If you need to edit and update changes you need to use a dataset.
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
execute SQL statement.....and fill a DataSet with your information if you use ACCESS as a database and VB.NET as your language then follow... Dim mySql AS String="SELECT * FROM myTable" //Suppose you have a DataAdaptor(da) And DataSet(ds) Dim ds As DataSet Dim da As OleDbDataAdapter da = New OleDbDataAdapter(mySql, myConnection) ds = New DataSet da.Fill(ds) //set DatSource of your datagrid to the dataset DataGrid1.DataSource=ds
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
you can have a HTML button control...but what you actually need????..... there DropDownList(and other controls) which has a click event and you can handle the postback also...but will it serve your need???
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
Retrieving column names of a table There are basically 3 approaches to this problem: 1.Use the sp_help procedure to get extended information about a database object. By database object, we mean a table, view etc. 2.You can use the following select statement to retrieve a table’s columns: SELECT TOP 0 * FROM table_name 3.The third approach, which I personally prefer, is using the schema object of SQL Server. For example, to retrieve the column names of Authors table, you can use the following SELECT statement: SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME 'authors' Which results in the following result set: column_name ---------------------------- au_id au_lname au_fname phone address city state zip contract (9 row(s) affected)
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
In the crystal report designer when you are creating a new parameter possibly there is a CheckBox which says "Allow Multiple Values".Did u check that??
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
Look at this........... http://www.vbforums.com/showthread.php?s=&threadid=296315[^] http://www.freevbcode.com/ShowCode.Asp?ID=1287[^]
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
I think A cursor is a server side thing. You can't "return" this to a client. Anyway why do u need this??
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
Returning only the first N records in a SQL query differs quite a bit between database platforms. Here's some samples: Microsoft SQL Server SELECT TOP 10 column FROM table PostgreSQL and MySQL SELECT column FROM table LIMIT 10 Oracle SELECT column FROM table WHERE ROWNUM <= 10 Sybase SET rowcount 10 SELECT column FROM table Firebird SELECT FIRST 10 column FROM table
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
Firstly you have many checkboxes....I want to know whether you have maintained the same convention while naming your checkbox control....i.e ckfld1,ckfld2,ckfld3,ckfld4...???? If a specific set of checkboxes are to be unchecked then matrixcoder has rightly said to put your checkboxes in a Panel.Then you can write For Each ctrl As Control In Panel1.Controls CType(ctrl,CheckBox).Checked=False Next Other wise you have to Split the ID of your checkboxes to have the number....you can use Substring method of string Class to do that. After that you can use that number in a For-Each loop to uncheck your CheckBoxes.But it should be a second choice I think.
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
There is plenty of resource in the net....try google..... see this http://www.codeproject.com/aspnet/crystal_report.asp[^] http://dotnetjunkies.com/Article/790775A0-C493-46D8-ABE0-40CA588D33D3.dcik[^] http://www.aspfree.com/c/a/ASP.NET/Programming-Crystal-Reports-with-ASP-NET-2-0/[^]
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
ASPnoob wrote:
I don't understand three lines of the code above. what does the following mean? Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("myDB"))
There is a Configuration file(web.config in case of web application and App.config in case of Windows application) where we can set the connection string as well as other configuration settings of our .NET solution.This is an XML file.Under the appSettings node the connection string is written with the string variable name myDB.whereever in the project you need to reference the connection string you will get it by ConfigurationSettings.AppSettings("myDB")
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
CCG3 wrote:
I am just working to modify it and change the way that some things show
What to show and in which way you want??
CCG3 wrote:
I am connecting straight to the database
if your work demands showing just full content of a table you can straightway do this..Otherwise if you have some specific query then you have to go for a typed Dataset(.xsd) to do this....populate the dataset with your query....make the Datasource of your report object to that Dataset.....
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
you can use a datagrid........or a grid like control... yes it is possible to split your record in a stored procedure...
Tirtha Do not go where the path may lead, go instead where there is no path and leave a trail. Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist