Comments by Raj@88 (Top 54 by date)

Sir am using Access database..

Tadit Dash sir.. as we discuss ..i used the dataset, all is working properly ...but the problem is that , i couldn't fetch data in gridview2 from table2 (SlideShowTable2)..

can i send my demo ..can u please send me ur mail-id
thank you...

Ok..thanx..a lot :)

if i have a database, with login , employee1 and employee2 tables

and also have 2 grid views 1st grid view to fetch the data from login and employee1 ,

in 1st grid view have link button with name activate for each row n when i click that activate button the data move from employee1 to employee2 table (employee1 & employee2 have same structure) and grid view 2 used to fetch the data of employee2 ..in that case what will i used dataset or datatable..

Suppose i have 2 tables say-Login and Employee and there is relation between these 2 tables in one database and i am fetching data in grid view . on the grid i have one link button for each row , when i click that link button than that related row will move from one table two another table...in that case what will i use dataset or datatable..

kar diya mail...plz check it out..

i tried but not getting the solution

sir...give me ur mail id ...the id which u given is wrong..

U_id is field that present in LOGIN table.

U_id,U_name,U_Email,U_Mobile,U_password

am unable to send u..

yes ..value is copied.

Can anybody help me..?

Dnyaneshwar sir...can i send u the project on ur mail id ...if yes plz send me ur mail id...

i checked all things ..bt not getting the solution ...can plz help me out

thanx

no error...am unable show data in table 2 in grid view 2..

Thanx a lot sir....:)

i had send u mail ..plz check it out..thanx

plz check the code above....am not using update panel...

all is working sir..

query also correct..
i have data in 2nd table..

AM NOT ABLE TO FETCH THE VALUE IN 2ND GIRD FROM 2ND TABLE..

u told me two things..i did 1st thing properly working...2nd thing is not working...

not working...:(

i hv two table in my project Advertise1,Advertise2...the project is related to Advertising the business, when user insert data related to their business data will save in Advertise1 ...with start date and end date after completion the date the data of the particular user should move from Advertise1 to Advertise2...for that am using access database.

thanxxx

am not getting....!!!!...:(

thanx..mr.amit

i removed it..but

Error occurs
.The TargetControlID of 'CalendarExtender1' is not valid. The value cannot be null or empty.

this error is occurred when i removed it

Amit sir...

The TargetControlID of 'CalendarExtender1' is not valid. The value cannot be null or empty.

this error is occurred when i removed it

sir ..i mean to say dat...in my project ...user uploaded the image ..at the time of updatn the time and date will save in database...and i want to delete the image after 2 day/5 days automatically...

Mr.Prasad Khandekar i hv commented the delete query...if u remove it,,,the program execute properly but not update command

plz anybody help me...to solve this..

am using accsee database

sir can u send me any link or example..

thanx a lot..i am new in asp.net ...refrence ke liye koi books bata sakte ho...

Mr. amit...problem solved...

no error...only page refresh ho raha hain

hey...amit its working...bt page redirect nahi ho ra hain ..

hey...friend its workingggg...:)

kzzz let me try..

Prakash u hv any demo...

thanxsssssssssss a lot............

Aarti Meswania: can u join me with team viewer...

Same Error.......

kk

yaa..i have passed...den why dis happned...?...

mam...No value given for one or more required parameters....this error is occured.. :(

yes...mam..i want update the row..

sir...i know that bt...i want insert the data in particular row..where the data is already filled bt not these 2 colm ...for this i hv taken these value in session from another page...

wait...
the another page coding is given below..

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
using System.IO;

public partial class CreatAdverties : System.Web.UI.Page
{
OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());


protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bindcatogeryropdown();
BindAreadropdown();
}

}

protected void BindAreadropdown()
{
//conenction path for database

con.Open();
OleDbCommand cmd = new OleDbCommand("select * from AreaTable", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
ddlCreateAddArea.DataSource = ds;
ddlCreateAddArea.DataTextField = "AreaName";
ddlCreateAddArea.DataValueField = "AreaID";
ddlCreateAddArea.DataBind();
ddlCreateAddArea.Items.Insert(0, new ListItem("Select Area", "0"));
ddlCreateAddArea.Items.Insert(0, new ListItem("Select Category ", "0"));

}

protected void Bindcatogeryropdown()
{
//conenction path for database

con.Open();
OleDbCommand cmd = new OleDbCommand("select * from catname", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
ddlCreateAddCategory.DataSource = ds;
ddlCreateAddCategory.DataTextField = "CategoryName";
ddlCreateAddCategory.DataValueField = "ID";
ddlCreateAddCategory.DataBind();
ddlCreateAddArea.Items.Insert(0, new ListItem("Select Area", "0"));
ddlCreateAddCategory.Items.Insert(0, new ListItem("Select Category ", "0"));

}

public void ddlCreateAddArea_SelectedIndexChanged(object sender, EventArgs e)
{
string AreaID = ddlCreateAddArea.SelectedItem.ToString();
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from SlideShow where AreaName='" + AreaID + "' ", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
con.Close();
if (ddlCreateAddCategory.SelectedValue == "0")
{
}
}

public void ddlCreateAddCategory_SelectedIndexChanged(object sender, EventArgs e)
{
string CategoryID = ddlCreateAddCategory.SelectedItem.ToString();
string ArName = ddlCreateAddCategory.SelectedItem.ToString();
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from SlideShowTable where CategoryName='" + CategoryID + "' And AreaName='" + ArName + "' ", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
}
protected void btncreat_Click(object sender, EventArgs e)
{

////Get Filename from fileupload control
//String extention;
//String name = fileuploadimages.FileName;
//String name1 = name.ToUpper();

//if (name1.EndsWith(".JPG"))
// extention = ".JPG";
//else if (name1.EndsWith(".GIF"))
// extention = ".GIF";
//else if (name1.EndsWith(".JPEG"))
// extention = ".JPEG";
//else
// extention = "";


//String filename = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTi

what is the mistake...didn't getting..plz tell me..