Comments by solanki.net (Top 68 by date)

u know we cant create multiple primary key .if u want to apply primary key on two column then u will have to make composite primary key .can u tell why u need two primary key in a single table ?

do u have any doubt ?

If u add id column in tblComboDetails table then apply join on id column then u can get 3rd row but not 4th row because your second table has only 3 record .if your second table (tblComboDetails ) has four record then u can get 3rd and 4th row also.

your welcome

and declare _sum as global
static int _sum=0

Put the break point and check value is coming or not in total .

// I all ready told u use global variable .improve your logic
//Declare global variable int _sum=0;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { int total=0; if (e.Row.RowType == DataControlRowType.DataRow) { total = Convert.ToInt32(((DataRowView)e.Row.DataItem)["total"].ToString()); // its showing error in this line "cannot apply indexing with [] to an expression of type object.
_sum +=total;
} if (e.Row.RowType == DataControlRowType.Footer) { Label lblamount7 = (Label)e.Row.FindControl("Label27"); lblamount7.Text =_sum.ToString(); } }

send your code

show me your code

can u explain more ? if u click prev button then what r u doing i mean redirecting to first page or what ?

Your welcome

k

U should add name space like that


using BL;

k

can u explain how ?

suppose u have table that contain your all search result.
then session["Record"] =dt;// for storing table in session.
// if u want to get this session on other page then

DataTable dt=new DataTable();
dt=session["Record"] as DataTable;

if u r using javascript then i think we cant change .

same thing u will have to do .
change here only
SqlCommand cmd = new SqlCommand(" write query here for selecting data " );
sqlDataAdapter sda=new sqlDataAdapter (cmd);
DataTable dt=new DataTable();
sda.fill(dt);
then u can bind your controls
ex: textbox1.Text= dt.Rows[0][0].ToString();

k, Now on Edit button click event u should hit database for getting result(select * from tableName) and from front end u will have to send id(id of record that u want to edit ) .according to that id u will get datatable .
then u can bind your controls with table columns.

can i show your code what r u writing on click of Add button ?

your welcome.

then its difficult to solve your problem without checking your code.

k,then u should set validation group for your all controls .

sorry i thought u directly saying no for your code .

change your attitude next time when u asking help dont give response like that .i am not interested in your code u only asked for help then only i asked your code.

have u given same validation group name for any other control ? if not send code of your both grids

send me your code

suppose your child grid has textbox and link button 'Add' in footer .then u should do like that :

<footertemplate>
<asp:TextBox ID="txtName" runat="server" ValidationGroup="ChildFooter" >
<asp:RequiredFieldValidator ID="rfvName" runat="server" ValidationGroup="ChildFooter" ErrorMessage="Enter Name" ControlToValidate="txtName" >


<footertemplate>

<asp:LinkButton ID="btnAdd" runat="server" CommandArgument='<%#Container.DataItemIndex %>' CommandName="AddChild" Text="Add" ValidationGroup="ChildFooter">

because validation group is same for all .set different validation group name for child grid textbox and linkbutton .means it should same for these both control but it should not match with any other validation group name (mean unique)

declare @Stock int ,@Product int,@Total int
set @Stock=(select SUM(st.Prd_stock) from stock st inner join prodcut prd on st.Prd_Name=prd.Prd_Name and prd.Prd_chk=1)
set @Product=(select SUM(prd.Prd_qnt)Product from prodcut prd inner join stock st on st.Prd_Name=prd.Prd_Name and prd.Prd_chk=1)

set @Total=@Stock + @Product

it means finally u want to show sum of these two column ?

can u explain what problem r u facing ?

can u send your code ?

in rowcommand event after finding dropdown , u can check value of drop down and set visible=false for textbox and button .

can u show the code ?

then what is problem ? change your message here
ddlTest.Items.Insert(0, new ListItem("Select", "0"));

sry i did not get where u facing problem,if u table code then its easy to solve

have checked code for only digits like :123455 it accepting only digits
for string length i told set MaxLength property of textbox .

pls send your table code

This not wastage of time ,this is learn something new .wastage time means simply sitting and waiting for ready made solution .it is write is not 100% accurate but by using your brain u can modify it .

yes bro,after getting your message i tried for it i think it took around more two hours .

Because here <input id="amount" name="amount" value="" /> u did not set type
i mean u should write like that :

<input id="amount" name="amount" type="text" value="" />

Try this :
Regex regValid = new Regex("^[a-zA-Z][a-zA-Z0-9]*(-[a-zA-Z0-9]*$|_[a-zA-Z0-9]*$|.[a-zA-Z0-9]*$)?$");

It will allow like that :

test.99
te33.ttss33
test_ttssee3
-----------

but should set MaxLength of text.it is not checking minimum length of text .
On button click u can check minimum length of text .

I hope this will help u.

hey gentleman its my code so i sent u .before sending code i am not matching my code with others .

Your welcome .

firstly add name space

using System.Text.RegularExpressions;

protected bool fnValidateText()
{
bool flag= true;
Regex regCharacters= new Regex("^[a-zA-Z]*$");
if(!regCharacters.IsMatch(textbox1.text))
{
flag=false;
return flag;//it will return false when validation failed
}
return flag;
}

Yes .

u r calling two validation functions and if validation is success then your if part will executed otherwise else part will be executed.

Removing it will not change anything ? I am not understanding please tell me ?

it means that when your textbox contain only number then it will return stat=false;because stat default value is false and when textbox contain only number then it will not change .

this code is not for checking there is any number in textbox .this is for checking only number should be in textbox .if textbox contain any thing except the number then it will return stat= true.

Because u trying to convert Description of dropdown into integer so its not possible
cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));

ddlcity.SelectedItem.Text)// it return text Description of dropdown

u should try this

cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedValue.Tostring()));

your welcome

it means every time after deleting record from grid u will have to hit database .
on rowDeleting event find id of row like that :
Label lblid = (Label)gvHardware.Rows[e.RowIndex].FindControl("lblId");
send this id with special parameter(like "Delete") and check in database value of special parameter and delete record using id .
after deleting record again u will have hit database for binding grid .

Enjoyyyyyyyyyyyy

public void buildgrid() { da = new SqlDataAdapter("bofc_prod", con); ds1 = new DataSet(); da.Fill(ds1);
viewstate["table"]=ds1.Tables[0]//Add this line
Grid1.DataSource = ds1.Tables[0]; Grid1.DataBind(); Grid1.Visible = true;

}

// And modify your existing code on rowdatabound event

DataTable dt = ViewState["table"] as DataTable; if(dt.Rows.Count>0 && dt!=null) {
then write code here .
}

i asked after saving record what code u write for getting record from database .because when on page load or page refresh ,u will have to bind grid .what code u r writing to get record from database ?

because table does not exist .so tell me,after saving record in database, how u getting record from database for binding in grid

tell me table contain record or not
DataTable dt = ViewState["checkbox1"] as DataTable;

if(dt.Rows.Count>0 && dt!=null)
{
then write code here .
}
put break point and check table contain record or not

firstly u check easily
Convert.ToBoolean(dt.Rows[e.Row.RowIndex]["check_bit"].ToString());
i am converting in boolean and y r taking varchar in database so how is it possible so modify this line like that

string check_bit=(dt.Rows[e.Row.RowIndex]["check_bit"].ToString());

if (check_bit == "1")
{
checkbox1.Checked = true;
}

tell me that in your table data is coming or not from database

null reference exception means your table not contain records if it is contain then tell me what is type of column ["check_bit"] in database .

send me your entire code and database table column name

u got error in this line

Boolean check_bit = Convert.ToBoolean(dt.Rows[e.Row.RowIndex]["Checkbox1"].ToString());//null reference exeption

["Checkbox1"] is not checkbox id ,it is table column name so give column name here .
pls tell me it solved your problem or not ?