Yes. you have to use a SELECT statement with WHERE condtion before inserting the user information.
See the sample code below
'Change your database name and path
Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TestDB.MDB"
Dim con As OleDbConnection = New OleDbConnection(strConnection)
con.Open()
'construct your where condtion
Dim strQuery1 As String = "SELECT EMPNO FROM FDXUSERS WHERE EmpNo = " + employeeNo
Dim aCommand1 As OleDbCommand = New OleDbCommand(strQuery1, con)
Dim objExist As Object = aCommand1.ExecuteScalar()
'construct your INSERT statement here
Dim strQuery2 As String = "INSERT INTO FDXUSERS VALUES(4, 'John', 30000, 20)"
Dim aCommand2 As OleDbCommand = New OleDbCommand(strQuery2, con)
If objExist Is Nothing Then
aCommand2.ExecuteNonQuery()
End If
con.Close()
The index of the first column starts with 0 and last index is 'Total columns' -1. That is if your GridView has 7 columns then the last index will be 6.
Also you can hide a column in a GridView by the following method
DateTime m_StartDate, m_EndDate;
DateTime db_StartDate, db_EndDate;
//Write code m_StartDate and m_EndDate from the web page
/*
m_StartDate = Start Date from the web page
m_EndDate = End Date from the web page
*/
/*
* Write code to get Start Date and End Date from
* the database using a data reader
* fill it in the followin variables
db_StartDate = Start Date from db
db_EndDate = End Date from db
*/
bool isValidRange = false;
if (m_StartDate <= m_EndDate)
{
if ((m_StartDate >= db_StartDate) &&
(m_EndDate <= db_EndDate))
isValidRange = true;
}
if (isValidRange)
Response.Write("Valid date range");
else
Response.Write("Invalid date range");
Also you can pass the m_StartDate and m_EndDate values to a stored precedure where you can validate the date range and return a boolean value based on that validation.
if i need to retreave mor than one valu (lets say pasword and the first name ) is this code correct.
SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"' first name = '"+textBox2.Text+", con);
You are fetching password and first name based on user name. Therefore the WHERE condition need not to have first name.
It should look like SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"' , con);
void Page_Load(Object sender, EventArgs e)
{
// Manually register the event-handling method for the Command
// event of the Button controls.
Button1.Command += new CommandEventHandler(this.CommandBtn_Click);
Button2.Command += new CommandEventHandler(this.CommandBtn_Click);
Button3.Command += new CommandEventHandler(this.CommandBtn_Click);
Button4.Command += new CommandEventHandler(this.CommandBtn_Click);
Button5.Command += new CommandEventHandler(this.CommandBtn_Click);
}
void CommandBtn_Click(Object sender, CommandEventArgs e)
{
switch(e.CommandName)
{
case "Sort":
// Call the method to sort the list.
Sort_List((String)e.CommandArgument);
break;
case "Submit":
// Display a message for the Submit button being clicked.
Message.Text = "You clicked the <b>Submit</b> button";
// Test whether the Command Argument is an empty string ("").
if((String)e.CommandArgument == "")
{
// End the message.
Message.Text += ".";
}
else
{
// Display an error message for the command argument.
Message.Text += ", but the command argument is not recogized.";
}
break;
default:
// The command name is not recognized. Display an error message.
Message.Text = "Command name not recogized.";
break;
}
}
using System;
using System.Data;
public partial class DemoCheckBoxList : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//Bind CheckBoxList on page load
if (!IsPostBack)
BindCheckBoxList();
}
private void BindCheckBoxList()
{
//You can load the following DataTable from a database
DataTable dtBooks = new DataTable();
dtBooks.Columns.Add("Is_Chosen", System.Type.GetType("System.Boolean"));
dtBooks.Columns.Add("Book_Name", System.Type.GetType("System.String"));
dtBooks.Rows.Add(new object[] { true, "ASP.NET Programming" });
dtBooks.Rows.Add(new object[] { true, "Beginning Web Development" });
dtBooks.Rows.Add(new object[] { false, "ASP.NET for Dummies" });
dtBooks.Rows.Add(new object[] { true, "SharePoint 2007" });
dtBooks.Rows.Add(new object[] { false, "PHP Programming" });
//Binding DataTable to the CheckBoxList control
cblBooks.DataSource = dtBooks;
cblBooks.DataTextField = "Book_Name";
cblBooks.DataValueField = "Is_Chosen";
cblBooks.DataBind();
//Select/Unselect checkboxes based on the value of 'Is_Chosen' boolean column
//of the DataTable
for (int i = 0; i < dtBooks.Rows.Count; i++)
cblBooks.Items[i].Selected = (Boolean)dtBooks.Rows[i]["Is_Chosen"];
}
}
Does kosar.Rows.Cells[0].Text return string value?
For example if the argument 'name' is 'Product1' and the value of 'kosar.Rows.Cells[0].Text ' is also 'Product', but the condition kosar.Rows.Cells[0].Text == name returns false.
1. Impersonation will not require any account. It is optional.
2. setting it to true work for all users then with each thier own folder and privileges. This is true. 3. If you set any account, then the application uses the privileges of that account to access the folder.
