|
need to brush up your core knowledge
private void Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
}
private void Bind()
{
DataTable table = new DataTable();
dgis.DataSource = table;
dgis.DataBind();
}
how do you get data here man....
do one thing, write a funcion with full functionality
private void FillEmptyBind()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
table.Rows.InsertAt(table.NewRow(), 0);
dgis.DataSource = table;
dgis.DataBind();
}
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
nclauder wrote: private void Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
}
private void Bind()
{
DataTable table = new DataTable();
dgis.DataSource = table;
dgis.DataBind();
}
you are creating seperate tables to get data from database and binding it to datagrid, thats why its not working. may be try something like this
private DataTable Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
return table;
}
private void Bind()
{
dgis.DataSource = Fill();
dgis.DataBind();
Regards
Shajeel
|
|
|
|
|
Thanks,
Shajeel Your advice has worked. But I've gotten another problem. When I press the button to add a new row it does not bring a new row.The button is bttnew. the code is now looking like this.
private DataTable Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
return table;
}
private void Bind()
{
dgis.DataSource = Fill();
dgis.DataBind();
}
private void InsertEmpty()
{
DataTable table = new DataTable();
table.Rows.InsertAt(table.NewRow(), 0);
}
private void bttnew_Click(object sender, System.EventArgs e)
{
// inserting
dgis.EditItemIndex = 0;
// modify text
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[0];
ecc.UpdateText = "Insert";
// fill table, insert empty row, bind to datagrid
Fill();
InsertEmpty();
Bind();
}
private void dgis_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
// stop editing
dgis.EditItemIndex = -1;
switch (e.CommandName)
{
case "Insert":
break;
case "Update":
break;
case "Cancel":
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[4];
ecc.UpdateText = "Update";
break;
case "Edit":
// begin editing
dgis.EditItemIndex = e.Item.ItemIndex;
break;
}
// fill and bind
Fill();
Bind();
}
Thanks;
|
|
|
|
|
problem is same you are inserting row in different table and binding different table to grid.
Regards
Shajeel
|
|
|
|
|
Thanks Shajeel,
I'm still trying to see how I'm inserting row in different table could you please enlighten me more.
Thank you very much.
|
|
|
|
|
private void Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
}
private void Bind()
{
DataTable table = new DataTable();
dgis.DataSource = table;
dgis.DataBind();
}
private void InsertEmpty()
{
DataTable table = new DataTable();
table.Rows.InsertAt(table.NewRow(), 0);
}
Regards
Shajeel
|
|
|
|
|
Hi Shajeel,
Thanks for all. That means I've been Inserting the column in a new table. So I thought tried this and got an error when compiling:
The type or namespace name 'table' could not be found (are you missing a using directive or an assembly reference?)
This was what I tried:
private DataTable Fill()
{
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
return table;
}
private void Bind()
{
dgis.DataSource = Fill();
dgis.DataBind();
}
private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(), 0);
}
Thanks
|
|
|
|
|
do this, i think it will work
private DataTable table;
private void Fill()
{
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * from dbo.DashBoard", con);
adapter.Fill(table);
}
private void Bind()
{
dgis.DataSource = table;
dgis.DataBind();
}
private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(), 0);
}
Regards
Shajeel
|
|
|
|
|
Thanks Shajeep,
I'm no longer get a mistake. But I've still failed to add a new row I don't know why? I want at the press of button bttnew a new row should be inserted. is this write?
private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(), 0);
}
private void bttnew_Click(object sender, System.EventArgs e)
{
// inserting
dgis.EditItemIndex = 0;
// modify text
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[0];
ecc.UpdateText = "Insert";
// fill table, insert empty row, bind to datagrid
Fill();
InsertEmpty();
Bind();
}
private void dgis_ItemCommand(object source,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
// stop editing
dgis.EditItemIndex = -1;
switch (e.CommandName)
{
case "Insert":
break;
case "Update":
break;
case "Cancel":
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[0];
ecc.UpdateText = "Insert";
break;
case "Edit":
// begin editing
dgis.EditItemIndex = e.Item.ItemIndex;
break;
}
// fill and bind
Fill();
Bind();
}
|
|
|
|
|
nclauder wrote: case "Insert":
break;
you are doing nothing in insert case.
Regards
Shajeel
|
|
|
|
|
Thanks,
Still that can't solve the problem. But I think the problem should be some where this part of the code but I can't figure out where exactly.
private void InsertEmpty()
{
table.Rows.InsertAt(table.NewRow(),0);
}
private void bttnew_Click(object sender, System.EventArgs e)
{
// inserting
dgis.EditItemIndex = 0;
// modify text
EditCommandColumn ecc =(EditCommandColumn) dgis.Columns[6];
ecc.UpdateText = "Insert";
// fill table, insert empty row, bind to datagrid
Fill();
InsertEmpty();
Bind();
//dgis.DataBind();
}
Thanks
|
|
|
|
|
Let's say I have some data like:
Name Age Department
Jack 23 IT
James 25 IT
Hill 20 HR
Brett 19 HR
Clark 22 IT
Jean 24 HR
June 21 HR
Zak 23 IT
Xavier 18 IT
How possible is it to pagenate my GridView using the data in Department column such that all in IT department appear on one page and all in HR department appear on a different page. Wouldn't mind sample code or links
-- modified at 3:56 Tuesday 27th February, 2007
|
|
|
|
|
scored. Nice question. trying to find out solution
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
i try to retrieve data from database and it store to xml and then manipulate the datas(add,edit,delete) and update in that xml file.finally that xml file stored in sql server with modification.
i solve these till xml modification and updating in xml file.but i cant able to store that updated xml file in sql server
RK
|
|
|
|
|
Load it in DataSet and update in database.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
Hi every body
I have a SQL Database in my Program with one table with some columns, one of them is image type and i saved some image inside it.Now i want to show all the contecnt of That table into Datalist.
I did it, but i cannot show Images into DataList.
Please help me in this case.'
Thanks in advance for your help
|
|
|
|
|
Hi Can you add image button in the column to show images in the datalist ......
Never dont with Datalist but you can show images using Image button from database by converting binary to bitwise collection
<l>Thanks and Regards
Sandeep
|
|
|
|
|
its very easy dear
grab your data in a DataSet and then bind that DataSet to the DataList
You can use any datasource like objectdatasource, sqldatasource etc.
now you have to ceate <itemtemplate> put an image control in itemtemplate and bind the image field if you are fetching images from database to the image control.
follwoing is an example of my site
<asp:datalist id="dlModels" runat="server" repeatcolumns="8" repeatdirection="Horizontal" width="133px" height="60px" datasourceid="odsIamges" showfooter="False" showheader="False">
<itemtemplate>
<asp:image id="Image1" runat="server" imageurl="<%# "uploads/"+ DataBinder.Eval(Container,"DataItem.ImagefileName") %>" height="78px" width="68px">
Naveed Kamboh
|
|
|
|
|
i want username i.e. firstname or lastname in place of from's email-id. i am using pop3 mail server to retrive mails. i got from's email-id like avssiva@gmail.com.
but i want firstname or lastname in place of From email-id place.
ple any one give solution ...
siva
dd
|
|
|
|
|
Hello,
I have derived a class from CDBVariant and I want to write
a class derived from CDBVariant.
class V : public CDBVariant
{
V(V& var);
CString c;
};
I want a copy construtor for the above class .But I am getting compile time errors saying "copy constructor not available fo class v.
I have declared and defined an empty function for copy constructor in the .cpp file .
Then what must be the problem.
Am I not allowed to write a copy constructor ?
Prithaa
|
|
|
|
|
i want to display firstname or lastname or both (username) in inbox when i received mail. like gmail.com inbox.
this is very urgent
plz anyboby give solution
by
siva
dd
|
|
|
|
|
Hi Sandeep
I am having the xml file
<class>
and i want to add nodes <name>
eg
<class>
<name>test1
<name>test2
karan
|
|
|
|
|
Don't post new threads only reply the post
<l>Thanks and Regards
Sandeep
|
|
|
|
|
How can make a reminder messagebox with griview,buttons like "dismiss","remind me later" and others and also some textbox
nzibi
|
|
|
|
|
When i code an if statement in asp.net it doesn't execute the the statement properly, it always execute the else statement and sometimes it looses variables and declare the empty while they have values
nzibi
|
|
|
|