Comments by Member 9176543 (Top 25 by date)

Object reference not set to an instance of an object.
on the First Line.
I have verified all the id names.

Hi Tadit Dash,
I tried to loop it but it doesnt works. It throughs an exception
protected void btnsubmit_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in grdDailyReport.Rows)
{
int WithdrawalAmount = Convert.ToInt16(((TextBox)row.FindControl("txtWithdrawalAmount")).Text);
int Balance = Convert.ToInt16(((TextBox)row.FindControl("txtBalance")).Text);
string BankName = ((DropDownList)row.FindControl("ddlBankName")).SelectedItem.Value;
string WorkerLabour = ((TextBox)row.FindControl("txtWorkerLabour")).Text;
int PurchaseMatrialAmount = Convert.ToInt16(((TextBox)row.FindControl("txtlPurchaseMatrialAmount")).Text);
string PurchaseAgainst = ((DropDownList)row.FindControl("ddlPurchaseAgainst")).SelectedItem.Value;
string Comments = ((TextBox)row.FindControl("txtComments")).Text;
DataAccessLayer.SaveDailyReport(WithdrawalAmount, Balance, BankName, WorkerLabour, PurchaseMatrialAmount, PurchaseAgainst, Comments);

}
BindData();

Hi Tadit Dash,
The other controls works fine like if i hard code the txtComments field then all other controls works properly i.e i can perform CRUD operations
Here is my DataAccessLayer
public static int SaveDailyReport(int WithdrawalAmount, int Balance, string BankName, string WorkerLabour, int PurchaseMatrialAmount, string PurchaseAgainst, string Comments)
{
DataSet ds = new DataSet();
string CS = ConfigurationManager.ConnectionStrings["connectivity"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand command = new SqlCommand("usp_sel_DailyReport", con);
command.CommandType = CommandType.StoredProcedure;
SqlParameter ParamWithdrawalAmount = new SqlParameter("@WithdrawalAmount", WithdrawalAmount);
command.Parameters.Add(ParamWithdrawalAmount);
SqlParameter ParamBalance = new SqlParameter("@Balance", Balance);
command.Parameters.Add(ParamBalance);
SqlParameter ParamBankName = new SqlParameter("@BankName", BankName);
command.Parameters.Add(ParamBankName);
SqlParameter ParamWorkerLabour = new SqlParameter("@WorkerLabour", WorkerLabour);
command.Parameters.Add(ParamWorkerLabour);
SqlParameter ParamPurchaseMatrialAmount = new SqlParameter("@PurchaseMatrialAmount", PurchaseMatrialAmount);
command.Parameters.Add(ParamPurchaseMatrialAmount);
SqlParameter ParamPurchaseAgainst = new SqlParameter("@PurchaseAgainst", PurchaseAgainst);
command.Parameters.Add(ParamPurchaseAgainst);
SqlParameter ParamComments = new SqlParameter("@Comments", Comments);
command.Parameters.Add(ParamComments);
con.Open();
return command.ExecuteNonQuery();


}
}

Hi,
What is Rows[i],i cant write i it says its not found.I tried
string Comments = Convert.ToString((TextBox)grdDailyReport.Rows[0].Cells[8].FindControl("txtComments"));
but the value in the comment variable is blank.
And how other fields are allowed except this Comment 1.

Hi,
I know that a new SP can be written but there would be a way to achieve this in a single SP,I want to know that.

Thank You.

Did you mean this
alter PROCEDURE usp_insertupdatepragimcrud
@EmployeeID int = null,
@Name varchar(50),
@Gender varchar(10),
@City varchar(50)
as begin
if(@EmployeeID is null)
insert into tblEmployeeDataAccessLayer (Name,Gender,City) values (@Name,@Gender,@City)
else
update tblEmployeeDataAccessLayer set Name=@Name,Gender=@Gender,City=@City where employeeid=@EmployeeID
end

Employee Id is set to is Identity,cant make it to allow nulls.

Thanks, as if now i am getting syntax errors when copying your latest solution trying to solve them,will update you when its done

Pallavi Waikar,

Yes it works correctly then the auto complete doesnt work.

Hi Pallavi Waikar ,

The entire code that you gave above works fine the thing is that if we clear the textbox then the entire Data is visible.

Hi Nila1991,

I dont want to bind textbox in gridview,have to bind it with gridview.
Ex you are a user and you enter India then the details of India should be displayed in gridview.

No error, nothing happens

Its not working, autopostback is true, after selecting value like kiran then it loads and shows the first initial in the textbox and gridview is not displayed

Hi Madhav Hatwalne,
I get a error in the C# code
'string' does not contain a definition for 'text' and no extension method 'text' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?)
Store Procedure
Create Procedure dsp_GridData

@flag VARCHAR(10),
@Value VARCHAR(10)
As
BEGIN
SET NOCOUNT ON
IF @flag = 'ID'
BEGIN
SELECT id,Name,Description FROM tblproducts where id = CONVERT(int,@value) /* AS your id is int*/
END

IF @flag = 'Name'
BEGIN
SELECT Name,Description FROM tblproducts where Name = @value /* AS your id is int*/
END


SET NOCOUNT OFF
END

C#
protected void ddllist_SelectedIndexChanged(object sender, EventArgs e)
{
string flag;
if (ddllist.SelectedValue.text == "ID")
{
flag = "ID";

}
else if (ddllist.SelectedValue.text == "Name")
{
flag = "Name";

}
// and so on for all other flag
string cn = ConfigurationManager.ConnectionStrings["connectivity"].ConnectionString;
using (SqlConnection connection = new SqlConnection(cn))
{

SqlCommand command = new SqlCommand("dsp_GridData", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@flag", flag);
command.Parameters.AddWithValue("@value", TextBox1.Text);
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

}
}

Vipin kumar
The value should come from the textbox
The above code just binds dropdown with gridview.

Thanks Ariana and Rohan.

And if a user selects the initial value then how to
Display a messsge ,"No Record Selected"

How do I confirm these two things
Have you conform that port 25 is open?
Smtp is white listed.

My intension was not to waste any ones time, its true that the above mentioned code is not copy pasted properly I have typed it and as per your comment the missing method is already mentioned above, infact there is a compile time error here Msg.Body = myString.ToString();
Before posting my query I have searched the web for examples major examples belongs to sending email through gmail which is running properly but rare article on sending through newly hosted domain name.
Correct code is
MailMessage Msg = new MailMessage();
Msg.From = new MailAddress("sales@mydomain.com", "Testing");
Msg.To.Add(TxtEmail.Text);
Msg.Subject = "Send Mail with HTML File";
Msg.Body = "Test";
SmtpClient client = new SmtpClient();
client.Host = "mail.mydomain.com";
client.Port = 25;
client.Credentials = new NetworkCredential("sales@mydomain.com", "password");
client.Send(Msg);