naag
-
Posts
21 -
Joined
-
Last visited
naag's Achievements
Newbie (1/7)
3
Reputation
-
thankz for ur reply ....problem is to get the data from the stored procedure....sql connection is proper but im enable to get the data using stored procedure....???!!!
-
hello... I have written a stored procedure to get a column Named as "Name" from the table DN_Software.The query is "Select Name From DN_Software Where DN_DiscoverHostID=5" for Particular ID. Now i want to display that list of names in front end page. please help me how to display using that stored procedure using asp.net displaying in c#.please... "ALTER PROCEDURE [dbo].[DN_Software_Read_Distinct_Name_By_DiscoveredHostID]( @Active [int], @DN_DiscoveredHostID Int) AS SELECT DISTINCT Name FROM DN_Software where DN_DiscoveredHostID = @DN_DiscoveredHostID --EXEC DN_Software_Read_Distinct_Name_By_DiscoveredHostID @Active = 1, @DN_DiscoveredHostID = 5" --------------this my stored procedure.
-
Hello...Everyone... Myself Nagaraj... Good to see you all...
-
Thanq for the solution but...in my case there is no "web form" folder in particular path ...even i searched in whole system....still unable to solve that...
-
Hello everyone....!! In visual studio 2012 "web form" template has missed ...how to add or re-install the template....itz urgent ...and I tried to solve this by running the commond "denven/installvstemplates" in vs 2012 commond prompt but still iam unable to solve this ...please someone help me to solve this as soon as possible... plz plz plz.....!!!!
-
Hello everyone....!! In visual studio 2012 "web form" template has missed ...how to add or re-install the template....itz urgent ...and I tried solving by running the commond "denven/installvstemplates" in vs 2012 commond prompt but still iam unable to solve this ...please someone help me to solve this as soon as possible... plz plz plz.....!!!!
-
Hai..every one...im getting this error " Could Not Execute LINK.EXE" while compiling in vb 6.. thankz..in advance..
-
hello...everyone. im getting this error whenever i start my system .on Desktop it will show this Error"call was canceled by the message filter.(Exception from HRESULT:0x80010002(RPC_E_CALL_CANCELED))"i donno what it is...please someone help me...im using Asus X54H ,Windows 7.. Thanku..!! -
Thank you boen_robot ...!!! even i have went throgh like this articles...i need some understandable words with easy way....that i got from you thanku once more.
-
hello.. friends....please someone help me...just i need advantages and disadvantages of microsoft enterprise library over web and windows applications.Thank you in advance...!
-
hello.. friends.... please someone help me...just i need advantages and disadvantages of microsoft enterprise library over web and windows applications. Thank you in advance...!
-
Hai... iam new for C# ...im learning ..i created a table and showing it...now i want to update,edit and delete the records...i did it in my way...Problem is whenever i give save ,addnew or delete button it shows "Object reference not set to an instance of an object."this error at line 120 " cb.DataAdapter.Update(ds1.Tables["workers"]);"my program. using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Windows.Forms; namespace naag_database{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } System.Data.SqlServerCe.SqlCeConnection con; System.Data.SqlServerCe.SqlCeDataAdapter da; DataSet ds1; int MaxRows = 0; int inc = 0; private void Form1_Load(object sender, EventArgs e) { con = new System.Data.SqlServerCe.SqlCeConnection(); con.ConnectionString = "DataSource=C:\\Users\\g.nagaraj\\Documents\\Databases\\naag.sdf"; con.Open(); System.Data.SqlServerCe.SqlCeDataAdapter da; string sql = "SELECT*from tbl_naag"; da = new System.Data.SqlServerCe.SqlCeDataAdapter(sql, con); ds1 = new DataSet(); MessageBox.Show("Connection Open"); da.Fill(ds1, "workers"); //GridItemCollection.Datasource = ds1; //GridItemCollection.Databind(); NavigateRecords(); MaxRows = ds1.Tables["Workers"].Rows.Count; con.Close(); } private void NavigateRecords() { DataRow dRow = ds1.Tables["Workers"].Rows[inc]; textBox1.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(4).ToString(); textBox2.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(3).ToString(); textBox3.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(2).ToString(); textBox4.Text = ds1.Tables["Workers"].Rows[inc].ItemArray.GetValue(1).ToString(); } private void btnNext_Click(object sender, EventArgs e) { if(inc !=MaxRows-1) { inc++; NavigateRecords(); } else { MessageBox.Show("No more Rows"); } } private void btnPrevious_Click(object sender, EventArgs e) { if (inc > 0) { inc--; NavigateRecords(); } else { MessageBox.Show("First Record"); } } private void btnLast_Click(object sender, EventArgs e) { if (inc != MaxRows - 1) { inc = MaxRows - 1; NavigateRecords(); } else { MessageBox.Show("Last record"); } } private void btnFirst_Click(object sender, EventArgs e) { if (inc != 0) { inc = 0; NavigateRecords(); } } private void btnNew_Click(object sender, EventArgs e) { textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); btnNew.Enabled =false; btnSave.Enabled =true; } private void updateDB() { System.Data.SqlServerCe.SqlCeCommandBuilder cb; cb = new System.Data.SqlServerCe.SqlCeCommandBuilder(da); cb.DataAdapter.Update(ds1.Tables["workers"]); } private void btnSave_Click(object sender, EventArgs e) { DataRow dRow = ds1.Tables["Workers"].NewRow(); dRow[4] = textBox1.Text; dRow[3] = textBox2.Text; dRow[2] = textBox3.Text; dRow[1] = textBox4.Text; ds1.Tables["Workers"].Rows.Add(dRow); updateDB(); MaxRows = MaxRows + 1; inc = MaxRows - 1; btnNew.Enabled = true; btnSave.Enabled = false; } private void btnupdate_Click(object sender, EventArgs e) { DataRow dRow2 = ds1.Tables["workers"].Rows[inc]; dRow2[4] = textBox1.Text; dRow2[3] = textBox2.Text; dRow2[2] = textBox3.Text; dRow2[1] = textBox4.Text; updateDB(); MessageBox.Show("Data Updated"); } private void btndelete_Click(object sender, EventArgs e) { } private void label5_Click(object sender, EventArgs e) { } private void labelUpdate() { label4.Text = "Record " + (inc + 1) + " of " + MaxRows; } } }
-
hai...everyone ... My problem is Whenever i start my laptop on the window it wil show " Unable to cast object of type 'System.Boolean' to type 'System.String'"this error...i donno anything about this pls...help me... thankq....
-
hi....im getting this error "The remote procedure call failed.[0x800706be]".when i open sql server configuration manager.TCP\IP in enable.please help me..Thankq...
